Ignoring Extra Spaces in Parameter Query

[jachbow]

I am trying to get my query so that any extra spaces before or after the user's input is ignored. I've already tried the criteria: Like "*"&[Enter .......]&"*"


Is this straight up wrong or is there a minor syntax error?
Also, if I were to want two parameters/an Or how would that look?
- I've been doing: Like "*"&[Enter .......]&"*" Or Like "*"&[Enter .......]&"*"


Thank you!

[Welshgasman]

Use Trim() ?

[jachbow]

That definitely seems like the exact thing I was looking for. I started learning Access a few days ago so I'm still kind of unfamiliar with the available functions.

Thanks for the help!

[CJ_London]

With regards your second question, you probably don’t want the same prompt text - could just add or remove a dot. And there should be spaces either side of the & though that may just be the way you have posted it.

And that should work in the query builder but is constructed differently in sql. Switch to sql view of your query to see what I mean

Whether to use OR or not depends on what you want, if the two entries are Sam and Fred then both will be returned. The alternative is to put on separate lines in the query builder - and repeat any other criteria you may have on both lines

Not clear whether you are trying to use * to get around the space problem but if not required, use = rather than like

And what do you want to happen if the user doesn’t enter anything for one or both prompts?

Generally better to use a form for the user to enter the search terms and have the query reference the form. Users should not be working directly with queries anyway

Good luck with your project