column manipulation

  • Thread starter Thread starter Mano
  • Start date Start date
M

Mano

How do I add columns in a query?
I need to add four columns, only when all the four columns contain numbers i
get the output else it is blank. Since all the columns are derived from
different queries i am not able to give a default value as zero. Kindly help
me
 
How do I add columns in a query?
I need to add four columns, only when all the four columns contain numbers i
get the output else it is blank. Since all the columns are derived from
different queries i am not able to give a default value as zero. Kindly help
me
Click to expand...

Use the NZ() function to convert Null to Zero. If your query contains number
fields A, B, C and D, any of which may be NULL, you can put

Total: NZ([A]) + NZ() + NZ([C]) + NZ([D])

in a vacant Field cell in your query to add up all four fields, treating
blanks as if they were zeros.
 
hi John
Thank you. You solved my issue in no time.
Thank u once again.

John W. Vinson said:
How do I add columns in a query?
I need to add four columns, only when all the four columns contain numbers i
get the output else it is blank. Since all the columns are derived from
different queries i am not able to give a default value as zero. Kindly help
me
Click to expand...

Use the NZ() function to convert Null to Zero. If your query contains number
fields A, B, C and D, any of which may be NULL, you can put

Total: NZ([A]) + NZ() + NZ([C]) + NZ([D])

in a vacant Field cell in your query to add up all four fields, treating
blanks as if they were zeros.
Click to expand...
 
Back
Top