User Defined Query

[JP]

I know this can be done, but it has been so long since I have done it!

I have a query that is meant to pull information on what offices (actual
rooms) fall under the control of each management officer. I would like for
the user to have to enter the management officers last name, space, first
initial (this is how the data will be in the table), then have the query only
pull the data for the specified officer.

For example, if Jane Smith is the mangement officer controliong 10 offices
(again, looking at rooms), I could enter "Smith, J." and the query would
create a report that only has her 10 offices.

Any help would be great!

jp

 

[Jerry Whittle]

Check out parameter queries in Help.

 

[John W. Vinson]

I know this can be done, but it has been so long since I have done it!

I have a query that is meant to pull information on what offices (actual
rooms) fall under the control of each management officer. I would like for
the user to have to enter the management officers last name, space, first
initial (this is how the data will be in the table), then have the query only
pull the data for the specified officer.

For example, if Jane Smith is the mangement officer controliong 10 offices
(again, looking at rooms), I could enter "Smith, J." and the query would
create a report that only has her 10 offices.

Any help would be great!

jp

Um?

That's a bit hard on the user. Why not give them a Combo Box (unbound, on an
unbound form) and let them *select* the officer name from a list, rather than
making them spell "Smith, J." (or "Wrylowskii, V.") and punishing them if they
miss a single letter?

You can base the combo box on a query such as

SELECT OfficerID, LastName & " " & Left([FirstName], 1) & "."
FROM Officers
ORDER BY LastName, FirstName;

Since you chose not to post any description of your table structure it's a bit
difficult to give a precise answer... but I think you're missing out on some
of the power of Access!