Query issue

[Marguerita]

Hi there. I created a query that selects a start and end
date. After realizing this is not the most efficient way
to retrieve information, since at least 6 people will
perform this action to obtain information for their
association. I would like the query, along with
requesting a start and end date, to request an association
number. I do not know how to do this and did not find it
in any past postings.
Thanks M~

 

[Scott M.]

I would like the query, along with
requesting a start and end date, to request an association
number.

My advice would be to place a combo box on your form.
When you make the combo box, have the wizard turned on.
If you have a table of these association numbers, base the
combo box from that, otherwise you can make a custom list
of the values you want them to look up.

Then, in the criteria of your query, place Like [forms]!
[whateveryourformnameis]![fieldname] & "*"

That should do sufficiently.

-Scott