Newbie needing to Group a field!

[Skydive]

Hi everyone,

I have only just had the need to start using Access, mostly i have taught myself. I have created a Database which tells me what pallets have been delivered and received by Customer. So far i am happy with the report. Down the left it reports by customer. BUT, if say in 1 day 20 pallets get sent, then another 20 later in the same day, it lists both entries. I want it to list a total, so it reads 1 total sum rather than a number of entries.

Any help appreciated, i have tried altering the Query and the report but i am either doing it wrong or i am amending the wrong section.

Any hep appreciated.

 

[JamesMcS]

You'd need to have a think about which field is causing the doubling up and either group by in the query or get rid of it altogether. So if it's delivery time for example, you'd have two sets of records if there were two delivry times for that customer for that day.