PC Review


Reply
Thread Tools Rate Thread

Creating a sum based on Order ID

 
 
javajoe128@yahoo.com
Guest
Posts: n/a
 
      30th Aug 2006
Hello

I have a database that captures orders for my customers. I have one
form where I enter the orders and the various line items. I am
building a second form to record payments. On the second form I would
like to see a total that captures the sum of the order amount for all
the various line items related to a particular order #.

The formula Qty. * Price works well for the first line of detail but
does not pick up subsequent detail lines of the order (for example if
customer orders more than 1 item).

Could someone provide some guidance on how to create this sum. FYI, I
am not overly familiar VB)

Thanks in advance.

Joe

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a running sum on a form based on order ID javajoe128@yahoo.com Microsoft Access Forms 0 30th Aug 2006 03:24 PM
Order clause based on value =?Utf-8?B?RHJhZ2Fu?= Microsoft Access Queries 2 20th Mar 2005 09:21 PM
Is it possible to set a sort order based on... Ted Microsoft Access Queries 3 16th Dec 2004 09:36 PM
Creating an order Chang Microsoft Access Form Coding 0 26th Jul 2004 06:28 PM
Re: Creating Sums in Report based Based on Query Duane Hookom Microsoft Access Reports 0 15th Jul 2003 06:39 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:42 PM.