Cross Table query

G

Guest

I have a cross table query that shows the total number of transactions each
person worked in my department by quarter per year. Is there any way to make
a quarter show up if there were no transactions?
 
A

Allen Browne

If the column headings are the numbers 1 to 4, you could force the column to
appear by setting the Column Headings property of the query like this:
1,2,3,4
 

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

How to build a "reach around" query? 5
Access Updating inventory levels 0
Duplicates not added in a Cross Tab Query 4
Criteria for results in report of previous year 5
lookup table in select query 2
Showing 0's in a group query 4
Calculate Start and End Date of a Quarter 8
Lookup with table 1

Top