Cross Tab Query and Missing Date(s)

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

Guest

Hi -

I have a cross tab query which breaks out the data using the dates as column
headers across the row. If there is no data for a date, the date is not
listed. How can I get ALL dates, regardless of data, to print and, if there
is no data, to list 0 as the field value?

As always, thank you.
 
Use the columns heading properties, fill it with all the dates you want.

To have 0 instead of NULL, in SQL view, instead of:


TRANSFORM someAggregate(someField)
SELECT ...



use


TRANSFORM Nz(someAggregate(someField), 0 )
SELECT ...



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top