Append / Update Table

[pickslides]

Hi all,

I have a table of customer compliants. It currently has about 14000 records. I have also created a number of queries that summarise the data for a range of reports.

I want to append any new complaints to the table to contiune the analysis. Also some of the old complaints have changed i.e. they may have been closed therefore the closed date needs to be updated.

My primary key is the complaint # as this is never repeated.

Is there a way to append the new data as well as updating any of the previous records?


Kind regards,

MQ

 

[liddlem]

Hi Pickslides
Unfortunately you haven't given us sufficient information to be able to provide a specfic solution, but here goes with a general answer.

To APPEND items - This is quite easy.
Create an APPEND query (with whatever rules apply) and run it.
You can run it from a button on a form if you wish.

As for CLOSED items - its just as easy
Create an UPDATE query (with whatever rules apply) and run it.
I would suggest that you create a SELECT query first to make sure that the correct rules have been applied. Then change it to an UPDATE
Again - You can run it from a button on a form if you wish.