Avatar of rinkydink
rinkydink
 asked on

MS Access 2010 SQL Query question

Hi -

I have the below query but I want it to return just the analyst name that starts with whatever characters are put in as the parameter (for example 'joh' but I can't seem to get it to come to fruition

The below sysntax returns everything that contains whatever the parameter was.....


Thanks for any help



SELECT *
FROM QTab
WHERE analyst Like '*' & [Enter Analyst here];
Microsoft AccessMicrosoft ApplicationsSQL

Avatar of undefined
Last Comment
rinkydink

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rey Obrero (Capricorn1)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
rinkydink

ASKER
Boy I feel like a dummy now LOL

That was brain dead to the extreme on my part

Thanks

This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23