Filtered results without comparison operator

[Steve_Blackman]

Hi all, my wife is taking an introductory Access 2010 course and has run into a problem. Her assignment involves library books and their due dates where you have to run the Report Wizard on two tables to find books in circulation.

The difficulty she's running into is that the results she's getting include all the books, not just the ones that are currently circulating. Just to illustrate the point, take a look at the table below. Assume that today's date is July 1, 2014 and that all items with a due date in the past have been returned and not borrowed since. It's rather obvious which books are in circulation:

User	Title	Due Date
Aaron	Book1	05-07-2014
Becky	Book2	06-26-2014
Charlene	Book3	07-08-2014
Dave	Book4	07-13-2014

Now please keep in mind that this is a very basic course she is taking and there's been no mention of comparison operators. So the question is if you're just using the Report Wizard, is there a way to filter the results just so you get the due dates that are in the future?

[pbaldy]

Without a comparison operator? I don't see how. In the due date field of the query the report is based on I'd try:

> Date()