Query: Return Value

[shapper]

Hello,

I have an Insert Query as follows:
INSERT INTO web_MailingList ( SubscriberName, SubscriberEmail,
SubscriberDate )
SELECT [@SubscriberName], [@SubscriberEmail], [@SubscriberDate];

My question is, can I create a Query that follows this steps:

IF there is a table record where SubscriberEmail = [@SubscriberEmail]
Then
RETURN False
Else
INSERT new record
End

Is this possible in Microsoft Access Queries?

Thanks,
Miguel

 

[Neil Sunderland]

I have an Insert Query as follows:
INSERT INTO web_MailingList ( SubscriberName, SubscriberEmail,
SubscriberDate )
SELECT [@SubscriberName], [@SubscriberEmail], [@SubscriberDate];

My question is, can I create a Query that follows this steps:

IF there is a table record where SubscriberEmail = [@SubscriberEmail]
Then
RETURN False
Else
INSERT new record
End

INSERT INTO web_MailingList
(SubscriberName, SubscriberEmail, SubscriberDate)
SELECT [@SubscriberName], [@SubscriberEmail], [@SubscriberDate]
WHERE NOT EXISTS
(SELECT *
FROM web_MailingList
WHERE SubscriberEmail = [@SubscriberEmail])