Like query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to have a criteria using the like condition on a field. For example
the criteria Like [tbl_ALLO_HIER_FROM_COSTCENTER_FUNCTION].[allo_hier] & "*"
is under the field hier_cd. The query works, but only to a point. EX.
Allo_hier has NIC and NICDM. Hier_cd has NICDMQOL and NICHAS. There should
be three records as a result but only two records show up. NIC should be
associated to NICDMQOL and NICHAS. But only shows to be associated to NICHAS
because NICDM is associated to NICDMQOL, so showing only 2 records as oppose
to 3. Is there a way around this?
 
Alex,

My guess is that you are getting what you have asked for, which is probably
to identify all of those records where the [Hier_CD] contains a value this
is starts with the same string as the [Allo_Hier] field. If you think you
should be getting three records back, post some of the representative data
from your table as well, so we can test any solutions against.

Dale
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Count text values in a Access Field 0
Have both records from two queries/tables under one Query without related fields. 0
Need help with query results 8
Using query like source for masses emails 1
Access Access Query Criterion 1
Using IIF In Query Criteria 4
Export a query to a new database 6

Back
Top