Append Query

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
 
D

Dan Artuso

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?
 
Top