MS Access Query: Display First of, second of, third of a field
Posted on 2011-04-19
I'm new to Access but proficient with Office otherwise, so please bear with me.
I have a simple, two table set up for a doc database
The First Table:
ID Title Author Category Date
ID2 is connected to ID which is the primary key of table one. The second table holds multiple entires for each single ID number, one for each separate tag used to describe the document.
When querying records, I can create columns that will display the first tag and the last tag for each record, but not any of the tags inbetween. Is there a simple way to do this?
I can set it up to show all tags, but then the output has multiple entries per ID number, and I need a single row per record.
Sorry if this doesn't make sense and let me know what I can clarify.