By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,251 Members | 1,373 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,251 IT Pros & Developers. It's quick & easy.

Conditional Queries!

P: 1
Hi! How do I do a conditional query on access?

What I want is:

"If the client's gendre is male, then he will rececive a anual signature for the Motor Magazine, if the client's gendre is female, then she will recieve a Hands Free Kit"

Help, please...
Sep 8 '08 #1
Share this Question
Share on Google+
1 Reply

P: 50
Assuming that your prospects gender in your table is listed in a field called genderand the table name is tbl_Prospects;

Select * from tbl_Prospects where gender = 'Male'
Select * from tbl_Prospects where gender = 'Female'
Sep 8 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.