Cross-tab query question

  • Thread starter Anthony Viscomi
  • Start date
A

Anthony Viscomi

I have created a Xtab qry that has multiple fields I'm only concerned with
field that has a column heading named "Period"; my criteria for this field
is: Between "200401 and 200413" (my client works with 13 periods within a
year). The query woks fine, except that if there is not any data for a
period the qry won't display a column headding with a null value.
I understand that in most cases this is fine, but for this purpose I
won't like to see every Period 1-13 displayed. Is this possible?

Thanks in advance!
Anthony Viscomi
 

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

Trying to query off of a table field name 3
Cross tab date problem 1
Cross tab query solution 4
SQL question - Cross Tab query 2
Crosstab not showing null values/fields 5
Left Join Question 2
Xtab query question. 3
Query a crosstab query 2

Top