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

run query in microsoft access

P: 3
hi
i am trying to do sql query in microsoft access. i have two table member and loan table. in member table all the member details are listed
in loan table contains those members who have taken film. but my question is i have to show all the members from loan and member table who have not taken a film for specifc period. for this question i have set two dates to see all the members who have not taken any film in that period of time. this is very urgent i will waiting for your answers . please reply as soon as possible.
thanks
May 3 '10 #1
Share this Question
Share on Google+
1 Reply


TheSmileyCoder
Expert Mod 100+
P: 2,321
Join the tables using a oneway join, and then add the clause Is Null on one of the fields in the loan table.

Thats about the most precise answer I can give to your question, without you providing more details about the table structure.
May 3 '10 #2

Post your reply

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