I am new to Access and am setting up a customer orders database. I have set up an ordering table and a separate table for the order items. This seemed to be working adequately in forms, but when I set up reports to sum customer order totals/order totals for sales areas it multiplies the sum by the number of order items. I’d be really grateful for guidance on solving this.
Thanks!

Annie,

Is there a way you can email me a zipped file of the database you're doing? If you PM me, I'll send you the address and take a look at it.

B

That would be great - I am in quite a pickle with this! I'm having other problems as well - the main one being that I can't seem to set up the deletion of orders after archiving. I'm not sure what PM is, but can send you the file zipped up. Thanks in advance.
A

Have flu and not firing on all cylinders as you may have noticed! Can you send your e-mail address to [email protected]. I'm away for a few days with no online access so won't be able to send until Friday.
Thx
Annie