Query designer expression

Where are you using this statement?
Upload the object using it.

First attempt: remove ':'
What error are you receiving?

Am using in a query designer as an expression.  I can't upload due to confidentiality issues.

I can't upload due to confidentiality issues.

If I want to check, I need to recreate the issue, and not your database.
So I am asking you to recreate the issue with dummy data.

Let me see what I can put together

I'll get something together tomorrow to show you. I thought this would be easy by if course it isn't.

Gus gave you a suggestion for how to incorporate the date range in the sum but context matters and the expression would be different depending on where you needed to run it.

I was able to use Gus' code with modification:

TotalCurrentPeriod: Sum(IIf([PostDate]>=[Forms]![frmSelectDateRange]![txtStartDate] And [PostDate]<=[Forms]![frmSelectDateRange]![txtEndDate],[Amount],0))

But I'm going to award points to all who contributed, because everyone provided insight that really helps me, and start a new topic title "Query Designer Help Please".