Sorry I misunderstood! Raw and Flexible Packaging are both values in a
field, not field names. I have the projects sorted by these commondities, so
for example, there is the header "Raw Packaging" and then listed under this
heading is all the projects that deal with raw packaging.
:
Sorry, Mina, you did not list the fields in a way I can understand.
Is Raw Packageing a field name or a value in a field. Same with Flexible
Packaging.
Please tell me the field names you want to return and I will be happy to
post back with a good answer.
--
Dave Hargis, Microsoft Access MVP
:
I listed them below. I need "Raw Packaging" and "Flexible Packaging" to
appear together under the heading "Packaging" and the table they are from is
called "COGS Category".
:
There are too many problems to list, (sorry), how about you tell me the table
name and the field names you want included in the query.
--
Dave Hargis, Microsoft Access MVP
:
I created it using Microsoft Help. It's probably terribly wrong...don't
laugh! As I mentioned before, I need "Raw Packaging" and "Flexible
Packaging" to appear together under the heading "Packaging" and the table
they are from is called "COGS Category". Thank you in advance for your help!!
SELECT [ALL] {[*COGS Category.*] [COGS Category.] Raw Packaging [AS
Packaging] [, [COGS Category.] Flexible Packaging [AS Packaging] from COGS
Category
:
Post back with the SQL you are using and we can have a look.
--
Dave Hargis, Microsoft Access MVP
:
It is saying that the syntax is incorrect!! I'm sorry...I'm very new to
Access. HELP!
:
Use a query for your report and a calculated field to return the commodity.
Here is an example of how you can combine the two into packaging and leave
the rest as is.
SELECT IIf([Commodity] LIKE "*Packaging*", "Packaging", [Commodity]) As
Something
--
Dave Hargis, Microsoft Access MVP
:
I am creating a report that lists projects and is sorted by commodity. There
are several commodities listed. Two of them are "Rigid Packaging" and
"Flexible Packaging". Is there a way that I can have all the projects under
these two fields grouped together and be displayed simply as "Packaging"?
The only thing I can think to do is change them in the table they are tied
to. However, I want to keep them separate so I don't want to change the
information in the table. I just simply want to group them together for this
one report.
