Incorporate data from one query into another

[Boomshank]

Hello,

I have a query called Orders which has the following fields:

ClientCode
PayrollName
Frequency
Output
TimeStamp
Date
Count
PostCode
RunNo

There can be several entries for each RunNo. I have another query called BoxesDespatched which contains

ClientCode
RunNo
Boxes

What i need to do is incorporate the number of boxes from BoxesDespatched into the Orders query which i can do but it has been requested that only the first record of each RunNo. has the number of boxes and all others show as 0.

Can anyone help with this?

Many Thanks

 

[vbaInet]

I think you need a totals query. This might be of help:

http://support.microsoft.com/kb/290136

Also perform a search on this forum, there are lots of examples

Edit: Just noticed this might have been a double-post?