I have a parameter query which asks to enter in an Office number The problem is that there are office numbers which include letters, like 4044b. So when the query asks me to enter in office number I want to enter in 4044 and have all records displayed that have office of 4044 as well as anything else, like 4044b, 4044c, 4044d. How would I work that into the query? Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Parameter with number and letter... 2
- Thread starter abradford
- Start date
-
1
- #2
-
1
- #3
- Thread starter
- #4
thanks, however, off couse, i am failing to get this to work, do to me being newish and not knowing where to put parens...here is my code:
SELECT [Active Directory].LastFirst, [Active Directory].Email, [Active Directory].AgentNumber, [Active Directory].AGT, [Active Directory].BSO
FROM [Active Directory]
WHERE ((([Active Directory].BSO)=[Enter BSO]));
SELECT [Active Directory].LastFirst, [Active Directory].Email, [Active Directory].AgentNumber, [Active Directory].AGT, [Active Directory].BSO
FROM [Active Directory]
WHERE ((([Active Directory].BSO)=[Enter BSO]));
- Thread starter
- #5
- Status
Similar threads
- Question
