Parameter with number and letter... 2

[abradford]

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!

 

[AlexCuse]

where left(MyField, 4) = MyParameter

should do the trick.

Hope it helps,

Alex

A wise man once said
"The only thing normal about database guys is their tables".

 

[Golom]

or

where MyField LIKE & "'" & MyParameter & "*'"

 

[abradford]

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]));

 

[abradford]

sorry I have figured it out thanks to you both