Using # and * in query, NOT as wild cards

[enthrop]

This basic thing seem to have slipped my mind due to in use...

When designing a query, how do I scan for the STRING # and * without them being used as wildcards?

Thanks.

 

[enthrop]

Heh, I seem to like replying to my own posts..

Follow up question.

Say i have a table with a column, "Company Name," located in table tblCompany. (other columns have info about the company).

Over the course of time, things have been marked for deletion if the company name has a * attached to the end.

I also have another table (tblName) which is a big table of names.

The two are related by a 1 to many relation where each company has a unique "Company Key" (from tblCompany) and each name is related to a company (via the Company Key).

Therefore, whenever I want to delete a company, if I'm working through tblCompany, I have to open the subdatasheet for the tblNames and delete those names, then delete the company (otherwise Access won't let me 'cause the relation still exists).

Is there a way I can, once again, either make this more efficient (through a query?) or more automated?

It's a lot for me to scroll through these companies trying to eyeball things with "*"s and then deleting first the people, than the company.

 

[mpastore]

Instead of wild-card, use instr() for criteria...

InStr([myfield], "*&quot > 0
InStr([myfield], "#&quot > 0


Mike Pastore

Hats off to (Roy) Harper