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
|
|||
|
|||
Crosstab Report Problem when data missing
I have a crosstab report that reports activity. The activity is by date on
the vertical axis and day of week on the horizontal axis. My problem is that there is only occasional activity on Sunday. When there is no activity on Sunday, I get an error when I run the report because there are no entries for that column. Is there any way to insure that all Horizontal columns are filled or eliminated if there is no data? |
#2
|
|||
|
|||
Crosstab Report Problem when data missing
Open your crosstab query in design view. Right click up in the Table area
and select Properties (the dialog window should read Query Properties, not Field Properties). In Query Properties, set Column Headings to "Monday","Tuesday",..."Sunday" This will force the query to always return those columns, *in that order*, whether there is data for those values or not. It will *only* return those columns, so be sure they are an *exact* match for the data in your designated Column Heading field (i.e., use "Mon","Tues"..."Sun" instead, if that's what your data returns). Your query will now return a "Sunday" field, data or not, so your report should display without errors. HTH, "Ynot" wrote in message ... I have a crosstab report that reports activity. The activity is by date on the vertical axis and day of week on the horizontal axis. My problem is that there is only occasional activity on Sunday. When there is no activity on Sunday, I get an error when I run the report because there are no entries for that column. Is there any way to insure that all Horizontal columns are filled or eliminated if there is no data? |
Thread Tools | |
Display Modes | |
|
|