If Statement

[spaz9876]

I am trying to do an IF statement and need help!

If ([Days to Close] = "1-30") Then
[Display] = (Sum([Total Value Proposed])
End If

I want all the proposal amounts to add up to show how many are planning to close within 1-30 days. My formula isnt working. Can anyone help?

[boneKrusher]

use:

date () - 30 or date() + 30

[spaz9876]

The prob with that is its not a date field. The field has the values "1-30", "31-90", "91-150" and "151+" I want it to query all the "1-30" records and then from those, sum all the [Total Value Proposed]