access reports

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access 2002 Reports

Access 2002 Reports

resolvedResolved · Urgent Priority · Version 2003

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?

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.


 

Access tip:

Switchboard Startup

An option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed.

To achieve this, select Tools click on Startup. On the right hand side of the Startup screen you are able to select which form you want to open when you open you Access Database. Once you have selected this, there is a check box just below that says "Display Database Window", you need to uncheck this option. Then click ok.

Then when you close you Access database and re open it, the database should open with just the switchboard being shown


View all Access hints and tips


Server loaded in 0.09 secs.