Append Query won't work

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have an append query and want it to overwrite a record
if it has the same account number. How can I accomplish
this? I have looked through the Access help file and
can't find the answer.
Here is what I have: I have a patient info table and I
only want to have an acct. number show up once. Sometimes
I have the same account that will show up multiple times
but the only info that changes will be the payment info.
Should I have a separate table that keeps the payment info
in it so that I can track the different payments there
without having multiple entries of the same account info
in the patient info table.

TIA,

John
 
I have an append query and want it to overwrite a record
if it has the same account number. How can I accomplish
this? I have looked through the Access help file and
can't find the answer.
Click to expand...

Append queries do not overwrite records; they add records to a table. If
you are having a problem with duplicate records, use the Query Wizard to
create a Find Duplicates query and then delete the dupes.

Here is what I have: I have a patient info table and I
only want to have an acct. number show up once.
Click to expand...

You can set the Indexed property of your Acct Number field to "Yes (no
duplicates).
Sometimes
I have the same account that will show up multiple times
but the only info that changes will be the payment info.
Should I have a separate table that keeps the payment info
in it so that I can track the different payments there
without having multiple entries of the same account info
in the patient info table.
Click to expand...

Yes, definitely! Payment info should be in a separate table linked to the
main table using your Acct Number field.
 
I believe what you asked for is an update query. However, I would not want
to delete old payment info as it might come up. So perhaps a seperate table
that stores payment history is in order???
 
Back
Top