Access:Query:Producing one output from many records which have a common field.

R

R.Gunn

Out of a query which is being used to produce a picking list I need to
produce box labels.
The database is laid out such that in this query the same destination number
has multiple instances of items.

E.g.
Destination Item
AB001 Apple
AB001 Pear
AB001 Cabbage
AB002 Pear
AB003 Apple
AB003 Tomatoe
etc.

I only want one box label for each of these destinations.

How can I make the query show just one (the first?) record it comes across
for each destination. I am not interested in the "item" for the box labels
as the picking note is itemised. its just the destination + a few other
fields - county, state etc.

Many thanks
Richard
 

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

Similar Threads

Printing variable number of report copies 2
Query to show details of dataset when one type of data is still blank 1
Concatenate same field records into one. 14
Query to show 2 records from each unique entry in a field 2
Mail Merge with a many-to-one report/query 1
Displaying fields from one table in another table 11
how to update many-to-one 1
string together IIf statements into one text box? 3

Top