Totalling records with same date

[ismith]

Hello,

Ive got an order table with a few fields one of them being 'Paid' and one being PaymentDate

Paid is the amount someone has made a payment for
PaymentDate is the date the payment was processed.

Now what im trying to make is a End of Day Total page which will Sum up all the payments made on the current date.

Now ive created a query from my order table which displays all the orders that made a payment today and the Paid field is greater than 0.

Ive tried this code but its not working.

EndofDayTotal is my query that I have created which shows the payments on todays date.

SELECT SUM(Paid) FROM EndofDayTotal;

Ive got a txtTotal unbound text field which im trying to populate with the SUM of 'Paid'

can anyone help please?

Thanks..

 

[John Big Booty]

Have a look at a Totals Query. You could Group By the Date and Sum the Paid

 

[ismith]

Thanks for that mate.

 

[Probi]

Alternatively.....
If I have understood correctly, your page is already filtered with date. If it is so, you can use "=SUM(Paid)" in control source property of your txtTotal. You may have to use nz() with "0", if there is possibility of null value.....

 

[Shallo9]

Even better if you can use the below formula in control source. you can use as many conditions as possible.

DSum(ColumnPaid, TableName, Criteria<<paiddate=todaysdate>>)