Hey AccessForums,
Currently trying to come up with a way to break data that looks like this...
Item Finish 100 Black 100 White 200 Red 300 Black 300 White 300 Red
And create a query to return this...
Item Finish1 Finish2 Finish3 100 Black White 200 Red 300 Black White Red
The main problem I seem to be facing is that I don't have a Key field or ID field of any sort. Running a "Count" against "Item" only returns exactly how many there are, and without a keyfield I can't seem to come up with any way to select the data based on the count of "Item". I have a VBA script that does something similar--in that it concatenates the "Finishes" into one column (i.e. Black/White/Red), but that's not suitable for my end result.
Anyone able to point me in the right direction? One of the biggest challenges with researching access related things like this is I have no idea what to search. Very frustrating because I would rather help myself than bug you guys if I can help it.