Criteria wildcard

  • Thread starter Thread starter Gavelle
  • Start date Start date
G

Gavelle

I'm trying to group items together based on a series of numbers but the last
2 numbers don't matter.

For example
40-3558-23
40-3558-30
60-2583-13

I'd like to group so that any records with the top 2 numbers will be grouped
together and any records with the last number will be grouped separately.
I've got approximately 15,000 different numbers. Can you tell me how i
should write my criteria statement so that only the last two digits are wild?

Thank you in advance for your help!
 
Gavelle said:
I'm trying to group items together based on a series of numbers but the last
2 numbers don't matter.

For example
40-3558-23
40-3558-30
60-2583-13

I'd like to group so that any records with the top 2 numbers will be grouped
together and any records with the last number will be grouped separately.
I've got approximately 15,000 different numbers. Can you tell me how i
should write my criteria statement so that only the last two digits are wild?
Click to expand...


Not sure what you mean by "group".

If you want to filter for one group, the criteria could be:

Like "40-3558-##"
 
I don't think i'm explaining very well, sorry! I guess what i really want is
for the query to group on the first set of digits and dashes leaving the last
two digits as wild **. I'd like to write something like this
Like nn-nnnn-**
where the n's are any like numbers and the ** are not alike.
I don't know what to write in my criteria for the n's so that the query will
group only those digits together and disregard the last two.

I have a whole series of numbers, some match and some don't. Some have the
same beginning but the last two digits are different.

Thanks,
 
Gavelle said:
I don't think i'm explaining very well, sorry! I guess what i really want is
for the query to group on the first set of digits and dashes leaving the last
two digits as wild **. I'd like to write something like this
Like nn-nnnn-**
where the n's are any like numbers and the ** are not alike.
I don't know what to write in my criteria for the n's so that the query will
group only those digits together and disregard the last two.

I have a whole series of numbers, some match and some don't. Some have the
same beginning but the last two digits are different.
Click to expand...


I thought that's what I posted would do (# is a wildcard
character that matches any decimal digit.

OTOH, I still don't know what you mean by "group". If it
the standard query GROUP BY, then you need to explain what
you want to do the last two digits. If you want to discard
them, just group on a calculated field Left([the field], 8)
But idon't see how that fits in a scenario with criteria.
 
Back
Top