|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 9th, 2005, 08:30 PM
|
|||
|
|||
Total
Hi,
I created a query,which has TOTAL RETURN:[LeftReturn]+ [RightReturn], from INFORMATION table. LeftReturn and RightReturn are fields in the INFORMATION table. If I entered 1 in LeftReturn column and 1 in RightReturn column (entered in INFORMATION table), the TOTAL RETURN is 2. It works. The query works fine if I entered any numbers in both LeftReturn and RightReturn fields. However, if I entered numbers in LeftReturn or RightReturn, not both. The TOTAL RETURN at the query shows nothing. Please show me how to fix it. Thanks Loi 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Can a crosstab query perform a running total? | K. L. Collins | Running & Setting Up Queries | 3 | January 20th, 2005 11:14 AM |
| using a form parameters to open a report | jkendrick75 | Setting Up & Running Reports | 5 | January 14th, 2005 05:05 PM |
| Convert Negative Total | JulieD | New Users | 3 | September 19th, 2004 10:01 AM |
| Report showing current total, previous total and average total? | Richard Black | Setting Up & Running Reports | 3 | July 20th, 2004 01:22 PM |
| adding total cost from a month | Andrew | Worksheet Functions | 4 | May 17th, 2004 02:36 PM |
Linear Mode
