Access_help_rob
Registered User.
- Local time
- Today, 22:08
- Joined
- Jul 3, 2003
- Messages
- 66
Hi i am trying to run a report from some data in a query which is collected from a other tables and queries. In the report i have a graph which is based on the data in the query. When i run the report i get the error message "Cannot use the crosstab of a non-fixed column as a sub query. if i click ok the data on the report will be shown but my graph will be blank. however if i then go into design view of the report and then go to the preview option all the data is displayed on the report and the graph and it is all correct. if anyone has any help for this it would me much appreciated.
Rob
Rob