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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cross tab query solution 4
cross tab query outer join 1
Sorting in a Cross Tab Query 2
Cross tab heading update issue 7
report on a cross tab query 1
Cross Tab Query 3
Cross Tab Query and a Date Form 6
cross tab query 1

Back
Top