Update Reports

[Raja]

I have created a report from a table and I want the report to be
automatically updated when the changes are made to the original table. I
don't want to create a new report all the time!!

Any suggestions or recommendation would be appreaciated!!

Many thanks

Kindest Regards

 

[Allen Browne]

You are asking if you can add new fields to the table, and they will
automatically be added to the report?

No: that's not possible.

If you have a design that constantly needs new fields in your table, you
don't have the correct design for a relational database. You need to read up
on 'normalization.'

Here's a starting point:
http://allenbrowne.com/casu-06.html
and another example:
http://allenbrowne.com/casu-23.html
and further links:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html#DatabaseDesign101

 

[Raja]

Allen

Thank you for your response.

If I don't want to add new fields but just want to update data in teh
existing tables and want teh report that I might have created based on that
tabel to be updated how can I do that?

I hope this makes my query clearer!!

Many thanks

raja

 

[Allen Browne]

So you have several tables, with exactly the same fields. You created a
report bound to (say) Table1, and now you want it to read the data from
Table2?

If that's the case, open the report in design view, and set its Record
Source property to Table2.

Record Source is on the Data tab of the Properties box, when looking at the
properties of the Report (not the properties of a text box.)

 

[Raja]

Dear Allen

Thank you for your responses!! They have really helped in my understanding!!
But I simply want to create a report based on a single table and simply want
the report to update automatically if I amend the data in the table!! e.g. if
I change the name of the product to something else in the original table
then then I want the report to reflect this change !!

I hope I am clear in asking my question this time!!!

 

[Allen Browne]

If you change the data in the table (e.g. the field is named ProductName,
and you change the content of a row from 'oil' to 'motor oil'), then the
report will change automatically when you open it again.

If your table has fields named after the products (e.g. a field is named
'oil'), you will have to redesign everything if you change the field names.
That is not a relational design.