Search results for query: *

I am trying to figure out how to use these CASE statements. I have a Stored Procedure that is capturing some incorrect data. I need to to filter out base on 2 criteria: If USCATVLS_1 = "Latitude" then USCATVLS_2 = "Hum. Stem" else If USCATVLS_1 = "RHS" then USCATVLS_2 = "Rad. Stem" else...

I first apologize if this is in the wrong forum. I am new to SQL and I have a stored procedure question. I have 2 tables that I need to combine into one temp table. Table One (Distributor Information): DistributorID Tables Two (Item Information): Item Number, Class ID I need to create a...

I think I have read every thread on this subject but none really pertain to what I am trying to accomplish. I have a report that uses 2 subreports, one that totals all unposted sales and one that totals posted sales. I set up shared variables in both reports that i use to creates a total in...

I need to add up the "Qty" when the "P/N", "L/N", and "From" Here is my data: P/N L/N Qty From To sta-d1 k09714 1 N-FG STA-K21 STA-D1 K09714 20 N-FG STA-K21 STA-D3 K08949 3 N-FG STA-K21 STA-D2 K09720 5 N-FG STA-K21 MTP-PS2L 2 N-CNSBLK MT00092 MTP-PS2R 2 N-CNSBLK MT00092 MTP-PS3L 2 N-CNSBLK...

I have a spreadsheet in Excel where I will need to create a seperate worksheet with all the data in rows so I can import into our MRP program. Here is what my data looks like: P/N L/N Qty From To STA-P1 K09713 50 N-FG 1s1300 STA-D2 K09555 50 N-FG 1s1300 I need it to look like this...

I am trying to populate 2 fields with formulas for month and year. I can get them to use the numeric value for month, but I would like it to show the "mmm" format, but change the format in the VBA code rather than having to format the cells in excel. Here is my current code that makes the...

let me give you a little history on this issue. I have 2 Database link together. One is a progress database and the other is the excel spreadsheet. One of the progress tables (part_master) has a field called "product_line" which I have linked to the excel spreadsheet that has the following...

I am using the Environ("username") formula in a Default Value for a text box, but it is not returning my username. I am in a Windows Environment (2003 Server) and my computer runs Windows XP. I hope this helps

I have an AR Aging report that is supposed to not show totals are equal to zero. However I am still getting some groups that are showing when there totals are zero. Here is my group selection criteria: Sum ({@TotalAmt}, {ARCUSFIL_SQL.cus_no}) <> 0.00 and Sum ({@TotalAmt}...

I know this version is very old, but being in a start-up company, upgrading at this current time is not an option.. So here is my question.. I have a report that has about 8 tables within it, I think I have them all link correctly, but I am still getting numerous duplicate records whic throws...

Here is the format of the spread sheet in excel: Part# Serial# RMA# P4120 124,127 300 P4120 150,151,152 400 Is there a way I can create seperate records based on serial numbers if there is more than one serial number in that cell. For instance importing the...

I have a table that has the following fields: Report_Number Requirement_Number1 Requirement_Number2 Requirement_Number3 Requirement_Number4 Requirement_Number5 Requirement_Number6 Requirement_Number7 Requirement_Number8 Requirement_Number9 Requirement_Number10 Requirement_Number11...

I have a field called ItemCount with the following formula: If (PreviousIsNull ({ARLINH.Shipqty})) then {ARLINH.Shipqty} else If ({ARLINH.Docdate} = Previous ({ARLINH.Docdate}) and {ARLINH.Shipqty} = Previous ({ARLINH.Shipqty}) and {ARLINH.Itemkey} = Previous ({ARLINH.Itemkey})) then 0 else...

I have a table that needs to have a field indexed. We use BTrieve here and I am stumped on how to indexed this field (trxDate), which is a date field. Thanks

Below is an example of the results I get from a report I made in CR7: 000537 Moved Out Of QUA 1/30/01 Moved Into QUA 2/16/01 Moved Out Of QUA 2/20/01 Moved Into NOVA 2/20/01 Moved Out Of NOVA 4/11/01 Moved Into QUA 4/11/01 Moved Out Of QUA 5/3/01 This report is group my item...

I am writing a report that uses 2 parameter fields for a date range and when I choose for instance March 1 (Start Date) and March 31 (End Date). In the Select Expert I have used the between dates statement and even used: {RecDate} >= StartDate and {RecDate} <= EndDate But they are still not...

I have a report that is based on transactions of our product.. When a customer purchases a product our accounting software puts a -1 in the transaction amount.. If the product is returned, it gets a +1. My question is how can I omit those records that have been returned. I have tried to...

I try to run a compiled report on a non-CR computer and get a blank prompt that only has an OK button. Though the report still runs, this prompt is annoying. I am using CR7 with a B-Trieve DataBase.. Any ideas..

I have a database which contains a table &quot;fieldval&quot; which stores numerous data types (it wasnt my idea to create this table). Within this Table I have CR select all the records that correspond to 5 diffent vaiables (VancoCL, VancoPICC, VancoMID, VancoPeri, and PercVanco). When I run...

I have a formula field &quot;Total Outs&quot; that pulls its data from a table that contains many different values. How can I create a subtotal of &quot;Total Outs&quot; and Group them by &quot;Teams.&quot; It does not give me the option to subtotal. Could I create a formula that stores these...