Enter multiple Parameters for a Field

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

On Tue, 13 May 2008 15:36:01 -0700, Hannah
wrote:

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

[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).
--

John W. Vinson [MVP]