merge multiple entries in table

[rajsa]

Hi,



Sorry - I'm relatively inexperienced with Access, this is my last resort after scouring forums (fora?) and the web

I have a large number of items (plants) in an Access 2002 database, and need to produce a data sheet for each, pulling information from several tables. My plan is to create the data sheet using Word and mailmerge.

I have a query that pulls data from several tables. The problem is that each plant can have, say, two different scientific names (one old, one current), can be supplied in three different growth media etc., so for one plant there can be multiple rows in my query result.

When I use this query to mailmerge, of course I get one merged document per permutation, rather than one per plant that lists all the linked scientific names/growth media etc.

Does this make sense?

I need to know if I can merge the records in my query result to just have one record per plant.

Many thanks for any help. I'm willing to learn how to do this, but don't really know where to start.

[NoellaG]

Hi,

I think there are some grouping possibilities using word fields in your word mailmerge template, but I think the easiest way is to create a report in Access, where you can very easily group en order by.
This way you can easily create one sheet per plant.

greetings
NG