grouping text from multiples records into one field

G

Guest

I have a database with species records - the species table lists sampleID,
species, abundance, etc., a sample table lists samples, dates, recorders and
other information. I want to produce a table that will list each sample
along with a combined (comma separated) list of species for that sample. My
aim is to produce a map of samples which can be interrogated to give a list
of species - a simple query will produce a record for every species record,
whereas I want one for each sample. I suppose what I want is a text
equivalent of a sum of a group of values
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top