I have a table created by a query with a reference ID, author name, and chemical name as the fields. There is a many to many relationship between author name, and chemical name. Therefore the author name is being repeated for each unique chemical name. Is there any way to "list" all chemicals associated with one author in a single row or cell. Example.
Instead of Brent hydroxy
Brent acetone
I want Brent hydroxy acetone
I have attached a printout of the tables and query results for you to look at.
Don't feel obliged to respond as I am sure you are very busy with many questions from students. However any assistance you can lend would be greatly appreciated.
Instead of Brent hydroxy
Brent acetone
I want Brent hydroxy acetone
I have attached a printout of the tables and query results for you to look at.
Don't feel obliged to respond as I am sure you are very busy with many questions from students. However any assistance you can lend would be greatly appreciated.
