Append Query

  • Thread starter Thread starter MJ
  • Start date Start date
M

MJ

I currently have:
INSERT INTO tblClients ( Client_ID, Client_Name,
Client_Address, Client_PostCode )
SELECT tblClients.Client_ID, tblClients.Client_Name,
tblClients.Client_Address, tblClients.Client_PostCode
FROM tblClients
WHERE (((tblClients.Client_Name)=[Forms]![frmAdd_Client]!
[txtClientName]) AND ((tblClients.Client_Address)=[Forms]!
[frmAdd_Client]![lblClientAddress]) AND
((tblClients.Client_PostCode)=[Forms]![frmAdd_Client]!
[txtClientPostCode]));

As a append query. All the fields/forms exist. When I try
to run the query, give it the correct values it asks me
do I want to append 0 rows? Basically it's not working.

Any ideas?
Thanks
MJ
 
Hi,
What are you trying to do?
The logic of the query makes no sense to me.

If I'm understanding it correctly, you want to append a record only if the record
already exists, so you end up with a duplicate. Is that what you want?
 
Back
Top