Need to print a crosstab report without complete data

[Lkwdmntr]

Hello, I have a report that uses a crosstab query for 12 weeks. I would like to monitor the data even after a few weeks, but I get an error when running it without the data for the full 12 weeks.

When I run the query separately, it works fine, but the report is set up for all 12 weeks. Is there a way I can get it to print just blank for the weeks I don't have?

 

[Pat Hartman]

You have to force the crosstab to return 12 weekly fields. I can post an example that does the same thing for years that you may be able to adapt for your use.

Bound Denormalized Form

I've left the old versions here but ALWAYS go to the last post to get the current version. This database contains two examples (using the same technique) of how to take data that is properly normalized and display it so that it looks like a spreadsheet (rows displayed as columns) but is...

www.access-programmers.co.uk

 

[xavier.batlle]

Hello, I have a report that uses a crosstab query for 12 weeks. I would like to monitor the data even after a few weeks, but I get an error when running it without the data for the full 12 weeks.

When I run the query separately, it works fine, but the report is set up for all 12 weeks. Is there a way I can get it to print just blank for the weeks I don't have?

I thing you'll need a dummy table with 52 rows, one for each week of the year and join it with your data.

 

[theDBguy]

Can you post a screenshot of the report and query results? Thanks.