Select specific value dynamically

[Guest]

Hello, I can't figure out the terms to find this in Help.
I would like to have a query which will come up and prompt for the value for
a date field. As I noted, can't figure what MS calls this stuff.
TYIA

 

[Guest]

Hi Richard

In the critiera row place this

[Please enter a date]

Change the words if nes.

Hope this helps

 

[Guest]

Thanks Wayne, that worked.
Can someone tell me what the terms would be to find this in Help? I
exhausted all my variations of Criteria and Select.
Regards,
Richard

Hi Richard

In the critiera row place this

[Please enter a date]

Change the words if nes.

Hope this helps

--
Wayne
Manchester, England.

Hello, I can't figure out the terms to find this in Help.
I would like to have a query which will come up and prompt for the value for
a date field. As I noted, can't figure what MS calls this stuff.
TYIA

 

[Guest]

You can either press F1 and search Query Prompt

or follow this link

http://office.microsoft.com/training/training.aspx?AssetID=RC010969991033

Good luck


--
Wayne
Manchester, England.

Thanks Wayne, that worked.
Can someone tell me what the terms would be to find this in Help? I
exhausted all my variations of Criteria and Select.
Regards,
Richard

Hi Richard

In the critiera row place this

[Please enter a date]

Change the words if nes.

Hope this helps

--
Wayne
Manchester, England.

Hello, I can't figure out the terms to find this in Help.
I would like to have a query which will come up and prompt for the value for
a date field. As I noted, can't figure what MS calls this stuff.
TYIA