Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 27th, 2007, 03:29 PM
Registered User
 
Join Date: May 2007
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default =Sum in reports

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!


 
Old May 27th, 2007, 03:40 PM
Authorized User
 
Join Date: Apr 2007
Posts: 65
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

 
Old May 28th, 2007, 02:34 PM
Registered User
 
Join Date: May 2007
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

 
Old May 29th, 2007, 04:47 AM
Registered User
 
Join Date: May 2007
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by Grafixx01
 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

 
Old May 29th, 2007, 04:50 AM
Registered User
 
Join Date: May 2007
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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






Similar Threads
Thread Thread Starter Forum Replies Last Post
how to sum in for-each Gjella XSLT 1 October 2nd, 2006 08:48 AM
Help: Running Sum (or Cumulative Sum) timdasa VB Databases Basics 1 August 22nd, 2006 03:12 PM
comparision among crystal reports and Data reports avats Crystal Reports 0 April 13th, 2005 01:01 PM
sum ibelta Access 2 February 15th, 2005 08:53 AM
How to create/design reports with crystal reports BassmaniaQ Crystal Reports 0 December 14th, 2004 04:58 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.