grouping

[Guest]

Hopefully someone out there can help...in my table, i have a field called
product. The products, or at least an example, are:

tape - two sided
tape - masking
tape - duct
vent - white
vent - tan
vent - black

I want to be able to run a query so that my results combine the tape and
vent. In other words, I want the output to look like this:

tape
vent

How can this be done?

any help would be appreciated....

 

[[MVP] S.Clark]

I would have a table for Categories, and a table for Sub-Categories.

Tape and Vent are Categories.
Masking and Black are sub-categories

This has its own share of problems, but the alternative involves using InStr
to determine the location of the hypen, then extracting an characters prior
to it, excluding the space.

 

[Guest]

Sorry, but I'm not quite sure what exactly you're trying to do. It sounds
like some of your records read tape, and some of your records read vent. I
would suggest simply concatenating the two, using something like:

tape & " " & vent AS Product

except that it seems like they are in the same field.

Presumably, there's only one product in this field for any one record, so if
you wanted to display both vent AND tape, you'd need to display multiple
records, which is easy enough in a query.

I wish I could be of more help; perhaps you can provide a slightly more
detailed explanation of what you're trying to do.

-Chris

 

[jahoobob via AccessMonster.com]

Try putting this in the Criteria for the field:
Like "*" & [Search for 1] & "*"
and then in the Or:
Like "*" & [[Search for 2] & "*"