I am using a crosstab query and want 0's when no data is present

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jerri - 25 Mar 2005 19:02 GMT

I am using a crosstab query where the column heading is the months of the
year totals. When there is no data for that model during a month, I would
like a zero to be placed in the column. How is that done?

Thanks

Reply to this Message

Douglas J. Steele - 25 Mar 2005 20:46 GMT

Try using the Nz() function around whatever field's being displayed.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I am using a crosstab query where the column heading is the months of the
> year totals. When there is no data for that model during a month, I would
> like a zero to be placed in the column. How is that done?
>
> Thanks

Reply to this Message