K
kleivakat
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.
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.