Query desigin question

[Guest]

I'm working through my first database. I have about 1100 records, and if I
want to build a query (and ultimately a report) that gives me only records
meeting a certain criteria, how do I get the query to "ask" me for the input?
I am tracking employee locations at multiple sites and on multiple floors,
and want to build a query that asks me each time what floor I want to query.
Right now I built a query for each separate floor putting the floor number in
the query design view, but if I want to make changes to the query design, I
have to change it for all floors. If I have the query or report ask me what
floor I want, I can have only one query for that function.

Can someone point me in the right direction? Thanks.

 

[fredg]

I'm working through my first database. I have about 1100 records, and if I
want to build a query (and ultimately a report) that gives me only records
meeting a certain criteria, how do I get the query to "ask" me for the input?
I am tracking employee locations at multiple sites and on multiple floors,
and want to build a query that asks me each time what floor I want to query.
Right now I built a query for each separate floor putting the floor number in
the query design view, but if I want to make changes to the query design, I
have to change it for all floors. If I have the query or report ask me what
floor I want, I can have only one query for that function.

Can someone point me in the right direction? Thanks.

As criteria on the Floor column, write:
[What floor?]

 

[Guest]

Yes. Thanks!

KK

I'm working through my first database. I have about 1100 records, and if I
want to build a query (and ultimately a report) that gives me only records
meeting a certain criteria, how do I get the query to "ask" me for the input?
I am tracking employee locations at multiple sites and on multiple floors,
and want to build a query that asks me each time what floor I want to query.
Right now I built a query for each separate floor putting the floor number in
the query design view, but if I want to make changes to the query design, I
have to change it for all floors. If I have the query or report ask me what
floor I want, I can have only one query for that function.

Can someone point me in the right direction? Thanks.

As criteria on the Floor column, write:
[What floor?]