Date field to carry through all queries?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

starr.kim@synthes.com - 21 Oct 2005 16:10 GMT

I have subreports in a master report and the field all the queries
depend on is a date. I would like to only enter the date once but each
query asks me for the same information. Is there a way I can enter the
date once and have it carry through all of my queries for that report?

Thanks in advance for your help!

Reply to this Message

Duane Hookom - 21 Oct 2005 16:49 GMT

Use a reference to a control on a form.
WHERE [DateField] = Forms!frmSomForm!txtSomeDate

Signature

Duane Hookom
MS Access MVP

>I have subreports in a master report and the field all the queries
> depend on is a date. I would like to only enter the date once but each
> query asks me for the same information. Is there a way I can enter the
> date once and have it carry through all of my queries for that report?
>
> Thanks in advance for your help!

Reply to this Message