Like query

[Alex]

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?

 

[Dale Fye]

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