SUM Product Prices By Dealer and Date of Purchase

[vdanelia]

Hello Friends, I need your help..
on My form i want to implement smart sum filter by Dealer and Date of purchase (fields are dateofpurchase and dealer) I created unbound text box where i want the sum to be displayed... (I think that I need DSum function) I tried in such way =DSum("UnitPrice","DATA", "Dealer", "Dateofpurchase") something wrong

Thank you in Advanced

 

[pbaldy]

This should help with the proper syntax:

http://www.mvps.org/access/general/gen0018.htm

 

[vdanelia]

Not worked, I tried many variants

 

[pbaldy]

Post one and we'll fix it (note at the bottom of that link is a multi-field example). What are the data types of the 2 fields in the criteria?

 

[vdanelia]

Ohh, Can't figured out this Expressions........

=DLookup ("UnitPrice","DATA" & "Dealer","DATA", "Dateofpurchase")

I also Tried

=DSum ("UnitPrice","DATA" & "Dealer","DATA", "Dateofpurchase")


=DCount("*","DATA","Dealer = """ & [Dealer] & """ And Unitprice = """ & [Unitprice] & """ And Dateofpurchase = #" & [Dateofpurchase])

 

[pbaldy]

Try

=DSum("UnitPrice","DATA" & "Dealer = '" & Dealer & "' AND Dateofpurchase = #" & Dateofpurchase & "#")

 

[vdanelia]

Getting Error, Not working

 

[pbaldy]

You never answered my question about the data types, so I guessed. Can you post the db?

 

[vdanelia]

I'll Explain what i need:

My main table is DATA with fields: Dealer (entered the companies, from where the products were bought) data type text
Unitprice (the price of the product) data type Number
dateofpurchase (the date when the product was bought) data type date/time

 

[pbaldy]

Oops, I had a typo in there. Try

=DSum("UnitPrice","DATA", "Dealer = '" & Dealer & "' AND Dateofpurchase = #" & Dateofpurchase & "#")

 

[vdanelia]

Worked perfectly, Thank you pbaldy Very much

 

[pbaldy]

No problem, and sorry for the typo. Fat fingers and slow eyeballs.