How Do I Display Null Values for counts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi again,

i have a query which uses the counts from multiple other queries which are
linked by a union query. the output data i have is as follows


ID 0-15 16-30 31-45
1212 1 3
1111 2 5
1010 5

how do i get it to display 0 instead of blank field? I have tried the
following
NZ([0-15Mins],0) but this cuts out the blank fields altogether however i
need these left in. is the problem that the counts are based on text fields?
 
Use the nz() function.

e.g. Nz(Fieldname, 0)

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

Songoku said:
Hi again,

i have a query which uses the counts from multiple other queries which are
linked by a union query. the output data i have is as follows


ID 0-15 16-30 31-45
1212 1 3
1111 2 5
1010 5

how do i get it to display 0 instead of blank field? I have tried the
following
NZ([0-15Mins],0) but this cuts out the blank fields altogether however i
need these left in. is the problem that the counts are based on text
Click to expand...
fields?
 
Back
Top