Stop access thinking I'm using a wildcard (1 Viewer)

MattioMatt · Sep 5, 2018

Hello,

I'm trying to make a query to look for value in my column called 'Category'. The text I want to look for is as follows, *Logical Application*.

The asterisks are within the text it needs to find. However every time I try to put "*Logical Application*" in the criteria access changes the criteria to Like "*Logical Application*" but I don't want that to happen. I just want to find *Logical Application*.

How can I do this?

jdraw · Sep 5, 2018

I mocked up a table as follows

with this query

Code:

SELECT Departments.*, Departments.Departmentname
FROM Departments
WHERE (((Departments.Departmentname)="*LogicalApplication*"));

And it seems to work

Ooops; I see plog has answered while I was testing a revision.

plog · Sep 5, 2018

Applying logic to your *Logical Application* issue means that you have other values in Categories that contain "Logical Application"? Otherwise using 'Like "*Logical Application*"' should work fine.

If indeed you have other values in your Category field that do contain "Logical Application", the way to find the ones that are exactly "*Logical Application*" is to put an equals sign in the criteria:

="*Logical Application*"

Access is like every other Microsoft product--it tries to outhink you and ends up being a pain by auto correcting you incorrectly.

CJ_London · Sep 5, 2018

@Matio, to find what you want put the * in square brackets

WHERE (((Departments.Departmentname)="
[*]LogicalApplication
[*]"));

see this link for all about wildcards

https://support.office.com/en-us/ar...aracters-939e153f-bd30-47e4-a763-61897c87b3f4

Access is like every other Microsoft product--it tries to outhink you and ends up being a pain by auto correcting you incorrectly.

to be fair Apple not much different

plog · Sep 6, 2018

to be fair Apple not much different

More non-sequitor than fair.

arnelgp · Sep 6, 2018

sound familiar

https://www.access-programmers.co.uk/forums/showthread.php?t=299541&highlight=asterisk

Stop access thinking I'm using a wildcard (1 Viewer)

MattioMatt

Registered User.

jdraw

Super Moderator

Attachments

plog

Banishment Pending

CJ_London

Super Moderator

plog

Banishment Pending

arnelgp

..forever waiting... waiting for jellybean!

Similar threads

Users who are viewing this thread