If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Data not always available for crosstab report
I have created a crosstab query/report based on "No of Applications per
month" with the "Application Type" as the row and the "Month" as the Collumn headings. This works fine when there is data for every month - my problem is what do I do if for one year, there is no data for a particular month - I currently get an error because the month is not in the query??? |
#2
|
|||
|
|||
Data not always available for crosstab report
In query design view, open the Properties box (View menu.)
List all the possible choices beside the Column Headings property, e.g.: 1,2,3,4,5,6,7,8,9,10,11,12 -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "SteveC" wrote in message ... I have created a crosstab query/report based on "No of Applications per month" with the "Application Type" as the row and the "Month" as the Collumn headings. This works fine when there is data for every month - my problem is what do I do if for one year, there is no data for a particular month - I currently get an error because the month is not in the query??? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
sorting data in a report | David | Setting Up & Running Reports | 21 | October 14th, 2005 03:05 PM |
Has anyone seen this behaviour? What might it be? | tw | General Discussion | 4 | June 30th, 2005 03:23 PM |
To Sharkbyte and all: Calculate a total values in group level | Ally | General Discussion | 6 | June 13th, 2005 08:16 PM |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |
Help!! I'm running around in circles! | CathyA | New Users | 19 | December 12th, 2004 07:50 PM |