Total

  • Thread starter Thread starter Loi
  • Start date Start date
L

Loi

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
 
Loi,

TOTAL RETURN: nz([LeftReturn]) + nz([RightReturn])

HTH,
Debbie



| 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
 
Back
Top