Solved Access 2010 query parameters

[CosmicJest]

Hello,

How do I include a portion of a field in a query parameter?

For example, if one record's data in the field I'm querying is, say, "RPMX-1011" and another record's data is, say, "CO-0852", how do I tell the query I want all records that have "PM" appearing somewhere in the field?

 

[Kaktussoft]

select * from tablename where fieldname like "*PM*"

 

[Big Tom]

select * from tablename where fieldname like "*PM*"

i agree

 

[CosmicJest]

I'm sorry - it's clear to you two, but not to me. When you say "select * from tablename", does that mean I drag the * into my query? And what does "where fieldname like "*PM*" mean? Do I type "like "*PM*"" somewhere? I'm not getting the results I need.

 

[Kaktussoft]

You're making a query using fields drag and drop? Then make the query as complete as you can. Can you make a parameter query? for example can you make a query that displays the birthday and name but only of the persons with name "Johnson"? I don't know your skills so don't know who to explain

 

[CosmicJest]

Well, the query already exists (I've been using it for some time even tho it doesn't give me fully accurate results), so I opened it and changed to Design view so I can edit it. From there, I dragged the * from the available fields in the table I'm using into the query. Yes, I believe I could do a query for all people named Johnson with a certain birthdate.

 

[Kaktussoft]

Make the query as good as possible. After that change to sql view. Post sql statement here please.

 

[CosmicJest]

SELECT [Business Licenses].[Lic#], [Business Licenses].BusinessName, [Business Licenses].FName, [Business Licenses].LName, [Business Licenses].MailAddr, [Business Licenses].City, [Business Licenses].State, [Business Licenses].Zip, [Business Licenses].BsPh
FROM [Business Licenses]
WHERE ((([Business Licenses].[Lic#]) Like "*PM*") AND (([Business Licenses].TypeOfBs)="property management"));

 

[Kaktussoft]

your query is right!
It displays all fields listed after select. But only for those records where TypeOfBs="property management" and Lic# like "*PM*"

what's the problem????

 

[CosmicJest]

The problem is there are some licenses that have "PM" as part of their license number that are not being included in the query results. Perhaps it's because there is also other text in the "property management" field?

 

[Kaktussoft]

TypeOfBs="property management" is also part of the criteria
so "property management" isn't included. Nor is "property management 123"

Logic isn't it?

 

[CosmicJest]

OK - I got it! I changed TypeOfBs to: like *property management* and the missing records came up! Thanks Kaktussoft!