Query setup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

austin - 31 Jul 2007 15:08 GMT

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

Reply to this Message

Jeff Boyce - 31 Jul 2007 15:48 GMT

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

>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

Reply to this Message

Douglas J. Steele - 31 Jul 2007 15:48 GMT

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)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>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

Reply to this Message

austin - 31 Jul 2007 19:40 GMT

thank you both for your help

Reply to this Message