Stop access thinking I'm using a wildcard

[MattioMatt]

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]

I mocked up a table as follows

with this query

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]

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]

@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]

to be fair Apple not much different

More non-sequitor than fair.

 

[arnelgp]

sound familiar

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