Hi NG
I need to create a query wich shows me several fields of one record in
several records - in access97.
Well, here's an example:
ok, that's my table:
UniqeNumber Item1 Item2 Item3
123456789 ABC AFF GRR
987654321 EFF ABC ELB
And my query should look like this:
UniqeNumber Item
123456789 ABC
123456789 AFF
123456789 GRR
987654321 EFF
987654321 ABC
987654321 ELB
I tried different ways with creating an own field and entered in the
expression: "item: [item1] or [item2] or [item3]" --> This only shows
me that there is a value in one of those fields. The same with "and",
here it shows me that there is a value in all fields. I even trief to
put the records in several tables and put them together - but that
don't work too.
Do you have any Ideas how to solve this? I can't change the table
definition, because it's an already full working software.
Thanks a lot for your help
susanna