Hi
I am currently using Microsoft Access to use a read only sql database, which is constantly updated via another system.
I am creating a number of queries and reports in order to provide information to users.
However...
I have created a Query from tables in Access,with the fields:
Name, Surname, Group, Date, Event
I have created a crosstab query from this based on Event. This has created the following columns in the CrossTab query:
Name, Surname, Group, Date, GNC, GNX,GNH,GNO,MER
As you can see the Event field has been converted into the five fields, GNC, GNX, GNH, MER.
The problem I face is when i create a report on this data. I have created the report and was printing it on a year to date perspective, which worked fine. However when I attempt to print the report on a week to date, there are no field records for GNC, so the report gives an error saying that the Jet engine cannot create the report because it can't find any records for "GNC".
Is there any way around this, as the same problem will probably occur in the future, and I need the database to print the reports automatically upon the running of the program. It is to be used by people with little or no experience with Access, and has to be as easy as posisble, i can't have them going into report design view and deleting the GNC field so that it does not request it, as they do not have the knowledege to do re-establish the feild into the report.
Please Help! Its Kinda Urgent!
Social Networking Bookmarks