MS Access help again

[dragon2309]

Hey there, im in need of some help again, ive mastered validation rules, ive managed to get one that wont let anyone whos under 17 years old be entered in, that took a while to get right, lol.

Anyway, what im stumbling on now is a query, what i need to be able to do is run a query that will ONLY select and display the records wich have "NO" selected in the boolean field.

To help, it is a driving school database, and i need to run a query to be able to instanly see the customers that havent paid yet (hence the NO in the boolean field)


Can anyone help me out here or even point me in the direction of say a Access tutorial site or something


Thanks a lot, dragon2309

 

[dragon2309]

actually foget about the above problem, every time i search for hours for a fix and i post here then 10 mins after ive posted it works, lol. Anyway.....

ive got another question now, basicall, i want to select records witha query that fall between a certain date range.... using Now() to echo the system date, i want to select all records witht the date of Now() and two weeks before Now()...... any ideas...

dragon2309