How to write a macro that does a search on a field in a table??

[learning_access]

I need to design my access to perform a serach on my tables...I have designed it using Queries...with criteria set...however the user must enter the exact full data in order to search the result...e.g. the user must enter 1234 EXACTLY as it is to find the record of 1234 in the table...

So is there a way to perform a search that match only part of a field??like maybe the user enter just "12" and the system can still find the records of "1234 or 1233 or 1235" for her/him??

Thanks so much guys!!

 

[rat_b76]

How to write a macro....

Hi,

If you look at the following thread, this may help you with what you need:

http://www.access-programmers.co.uk/forums/showthread.php?t=67385&highlight=wildcard+query

Cheers

rat_b76.

 

[learning_access]

Hey that helps...thx so much!!^^