I am trying to run a report off a crosstab query. The report calls for columns A - F, which are returned from the crosstab query. The only problem is that at times some of the columns are not returned by the query because there is no data associated with them. The report asks for column X, and no such columns exists in the query result; thus, an error is generated. My question is: how do I deal with this problem? I would like to avoid having to build the report from scratch. Is there some way that at runtime I could programatically tell the report to ignore these fields?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Crosstab reports 3
- Thread starter marshw
- Start date
-
3
- #3
Go into the design of your Crosstab Query, go into the properties of the query and in the Column Headings place: "A","B","C","D","E","F"
Now, everytime the crosstab is run, Access will put in those columns whether there is data or not. Then you can reference them in your report without worrying if there's data or not.
HTH Joe Miller
joe.miller@flotech.net
Now, everytime the crosstab is run, Access will put in those columns whether there is data or not. Then you can reference them in your report without worrying if there's data or not.
HTH Joe Miller
joe.miller@flotech.net
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question