calculating the sum of a field in using access forms.

[mazenblue]

Dear All
i have the following problem and i am using microsoft access 2000 forms:-
i am working on a system for a store, and i have a table named orders (order id , order_date , order_price, order_company_o wner_name), and i have created a form for this table , what i am trying to do is that i want to add a field that calculate the sum of the prices for all the retrived orders (order_price) column for all the orders on the form that will be retrived after filtering the records (records - filter - filter by form) and i want the sum of those records to be calculted once the user click on the calculate button ?
thanks in advance

[puppydogbuddy]

Dear All
i have the following problem and i am using microsoft access 2000 forms:-
i am working on a system for a store, and i have a table named orders (order id , order_date , order_price, order_company_o wner_name), and i have created a form for this table , what i am trying to do is that i want to add a field that calculate the sum of the prices for all the retrived orders (order_price) column for all the orders on the form that will be retrived after filtering the records (records - filter - filter by form) and i want the sum of those records to be calculted once the user click on the calculate button ?
thanks in advance

Use the DSum function over your filtered domain:

DSum("[order_price]", "YourFilteredQu ery")

Or use DSum with where clause (see example below)

DSum("[order_price]", "YourBaseQuery" , "order_date < Xdate")

[lee123]

on the footer of the form add a text box in design view go to the properties of the text box find the controlsource and put this in the controlsource:

=sum(orderprice )

lee123

[mazenblue]

on the footer of the form add a text box in design view go to the properties of the text box find the controlsource and put this in the controlsource:

=sum(orderprice )

lee123

Many thnaks it works well , but i need to calculate the sum only when the user clicks on a button, not automatically.

[mazenblue]

any advice on how to calculate the sum of the prices only when i press on the calculate button???

[puppydogbuddy]

any advice on how to calculate the sum of the prices only when i press on the calculate button???

Here is one way that might work:
1. Set the visible property of the textbox with the calc to no in the forms current event.
2. Make it visible when you click the button:

Private Sub YourButton_Click()
Me.YourTextbox.Visible = True
End Sub

Private Sub Form_Current()
Me.YourTextbox.Visible = False
End Sub

[puppydogbuddy]

If you don;t want the calc to occur, visible or not, substitute enabled for visible in the above code.