Enter multiple Parameters for a Field

  • Thread starter Thread starter Hannah
  • Start date Start date
H

Hannah

Hi All,

I'm trying to create a parameter that allows you to enter two values. For
example, in my query I created a parameter to enter the brand so that the
query only pulls information for that one brand. I want to create a query
where you can select two brands so the report pulls up information for only
the two brands that are entered.

This is what my criteria currently looks like:
[forms]![frmEnterSpiritSalesP]![text5]

Thanks!
Hannah
 
Hi All,

I'm trying to create a parameter that allows you to enter two values. For
example, in my query I created a parameter to enter the brand so that the
query only pulls information for that one brand. I want to create a query
where you can select two brands so the report pulls up information for only
the two brands that are entered.

This is what my criteria currently looks like:
[forms]![frmEnterSpiritSalesP]![text5]

Thanks!
Hannah
Click to expand...

[forms]![frmEnterSpiritSalesP]![text5] OR
[forms]![frmEnterSpiritSalesP]![text6]

or, equivalently, put the two criteria on two consecutive lines in the query
grid (assuming there aren't any other criteria; if there are they'll need to
be repeated).
 
Back
Top