avoiding null errors

[smiley0q0]

i have a macro that runs an update query and then prints a report of 3 different clients, some days one client or the other does not have any new info, or no info for the date that is specified, right now the report prints a couple pages with errors all over it for the client that is missing, how do i have it not print anything if the client does not have any info

thanks for you help

 

[ghubbell]

Hello Smiley my star'y friend,
In the query that "drives" your report or in the field on your report I believe you could use the Nz (Null to zero) and/or IIF Functions:

IIf(Nz(varFreight) > 50, "High", "Low&quot

Check Access help on these two little functions as there's lots of decent examples to look at. Gord
ghubbell@total.net

 

[snyderj]

Without knowing the specifics of your macro I can only guess at a few options:

1. Perhaps an iif statement would help: if condition then do something or don't do something.

2. Perhaps null to zero would help (NZ) which might allow calculations to produce a zero rather than an error. (You may need to implement this through a module, which is pretty easy.)

3. Perhaps a condition statement would help by allowing certain statements to run in your macro only if certain conditions are met.

If you wish you could post your macro here or e-mail it to jeff.snyder@angelfire.com with the subject "avoiding null errors" and I might be able to get more specific.