By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,061 Members | 1,515 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,061 IT Pros & Developers. It's quick & easy.

Like/ Wildcard on Form

P: 1
I am working on an Access database. I have the main form with a text field ( NPC) and a subform with source query called NPC query. The only thing that NPC query displays is records where NPC<> 0.

The way the database is working now: A user can enter a NPC and the subfrom will give all the records in the query that have the specfic NPC that the user entered. The user has to know the whole NPC code in order to view the records.

I want the user to be able to enter in the first part of the NPC and the form return all the records that have that first part of NPC. NPC Like ' Me.NPC %'

I know how this could be achieved using Oracle and JSP but I don't know how to make this happen in Access. Can some of the Access experts help me with this problem.

Thanks in advance

Jul 25 '06 #1
Share this Question
Share on Google+
1 Reply

P: 179
You can use "LIKE" expression.

LIKE 'Mac%' will find all entries beginning with "Mac".

For single character, you can use the _.

Like 'j_n', will return jan, jen, jin, jon, etc.

Jul 25 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.