default to zero

[rsmack]

i use a query to summarize transaction data from several tables for presentation in a form. if a particular table has no entries, because there are not yet any transactions of that type, the query returns null values for that table. these are unusable for calculations, such as totals. is there some way to get a zero value into these queries, or in the controls on the form?

 

[TheAceMan1]

How are ya rsmack . . .

In VBE help have a look at the [blue]Nz[/blue] function . . .

See Ya! . . . . . .

 

[rsmack]

thanks aceman1,

this looks like something i'd have to do for every field. ?
is there a way to do this, uh, globally?

 

[TheAceMan1]

[blue]this looks like something i'd have to do for every field. ?
is there a way to do this, uh, globally?[/blue]

Not sure at this point . . . post this summarizing query/sql . . .

See Ya! . . . . . .

 

[BigheadTodd]

If you don't want to use the the 0 values, you can use in your SQL statement (or as a filter):

WHERE is not null



Hope I didn't butt in and interfere...

BHT

 

[TheAceMan1]

[blue]this looks like something i'd have to do for every field. ?
is there a way to do this, uh, globally?[/blue]

Not really. Nz is normally used in a calculation where nulls may be expected:

[blue]   Ans = Nz(field1) + field2
or
   Ans = Nz(field1) + Nz(field2)[/blue]

See Ya! . . . . . .