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

reports

ResolvedVersion 2003

Adam has attended:
Access Introduction course
Access Intermediate course

Reports

If you want to generate a constantly updating report, how do you do this without remaking the report each time you wish to see an updated version?

RE: Automatically Updating reports

Dear Adam

Thank you for attending Access courses. I hope you benefited from them and enjoyed the courses.

Please note just like Forms if you modify the information in the table it will automatically update the report. This includes adding data in the blank cells or ammending data within existing data value. I applogise for misinforming you on the course by saying that the data can't be modified once the report has been created.

If you wish to add a new filed in the table and want that to be displayed in the report that you have already created then simply Add the new filed in the table. Go to the design view of the report that you have based on this table and add the field from filed list dialog box.

I hope this helps.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!



Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.