variable query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

warren - 18 Nov 2007 12:33 GMT

Sorry im a newbie.
I have a simple table that has data with a week number.
how do i get a form to ask for a week number, then input that week number
into the query to show the results in a report?
Can anyone piont me in the correct direction?
Regards
Warren

Reply to this Message

Douglas J. Steele - 18 Nov 2007 13:05 GMT

One way is to put [Week Number?] as the criteria in the query. When the
query runs, a dialog box will pop up, asking the user for the value.

Another approach is to have a control on the form to which the user supplies
the value. (It can be a text box, a combo box, a list box, etc.). You'd then
put Forms![NameOfForm]![NameOfControl] as the criteria in the query
(replacing NameOfForm and NameOfControl with the appropriate names). The
form must be open when the query runs: Access will not open the form for
you.

Signature

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

> Sorry im a newbie.
> I have a simple table that has data with a week number.
[quoted text clipped - 3 lines]
> Regards
> Warren

Reply to this Message

warren - 20 Nov 2007 11:56 GMT

Brill, stumbled on the first one, the second one is what settled on.
Thank you.
Warren.

> One way is to put [Week Number?] as the criteria in the query. When the
> query runs, a dialog box will pop up, asking the user for the value.
[quoted text clipped - 13 lines]
> > Regards
> > Warren

Reply to this Message