Query setup

A

austin

I have a table of calls to make.

Is there a way to set a query up so that each day I go into the query it
will only show me the calls I need to make for that particular day?

thanks
 
J

Jeff Boyce

That depends...

Does your record have a [CallOnThisDate] field?

If so, create a new query, add the table, add the [PhoneNumber] and
[CallOnThisDate] fields, then put "=Date()" (without the quotes) in the
Selection Criterion "cell" under the date field.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
D

Douglas J. Steele

If you've got a date associated with each field, indicating when you should
call, set its criteria to Date().

If you want all those for previous days that haven't been marked as
completed, set the criteria for the date field to <= Date() and put False
under the Completed field (assuming it's a Yes/No field)
 
Top