Forum home » Delegate support and help forum » Microsoft Access Training and help » Access 2002 Reports
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access 2002 Reports
Resolved · Urgent Priority · Version 2003
Reply Mon 30 Mar 2009, 15:24Delegate Orla said...
Orla has attended:
Access Introduction course
Access 2002 Reports
In Access 2002 SP3 Reports there was a saved Report entitled Mailing Lists. I wanted to update the categories we have and so opened it in Design View. Here under the ID Header we have Surname, First Name and then a list of the various groups/categories to which people are signed up.
I wanted to delete one of these categories and alphabetically insert another one. So I clicked in the individual box, deleted the wording and overwrote it shifting each of the categoris to the left ending up with the relevant space to insert the new category. Now however it looks like this report is still drawing and assigning the original information to the 'old'/deleted category (although it has a new and thus incorrect name).
I have noticed that in the unchanged categories these seem to have an object assigned e.g. Do Not Mail_Label. How can I attach the relevant object to the newly named categories and get it to draw the correct information from the database?
For upcoming training course dates see: Pricing & availability
RE: Access 2002 Reports
Hello Orla
Thank you for your question, and apologies for the delay in response. We have been trying to figure out the best way to suggest a possible solution for this.
We think it is something to do with how you have entered the new category in your report, as essentially it sounds like you have overwritten the heading for the category you want to delete, but haven't deleted the data.
Our suggestion would be to try creating a very simple report showing the data you want to have included; then compare this to the existing report you have to see how they are different from each other. This might point you in the right direction with regard to why the report you have amended is not displaying the data you require.
Kind regards
Amanda
Mon 13 Apr 2009: Automatically marked as resolved.
|