run query in microsoft access

[125a29]

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

[TheSmileyCoder]

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.