Hi

We have a special reduced rate that a client must prepay 12weeks before or sooner if a date is put in the [OverRideDate] field

I have been trying to construct a Query / If statement or should I use case statement to work out the actual payment date. Taking in to consideration all our funny little variables like

I will try to put the variable into words

[DateOfArrival]-84Days unless [OverRideDate] & Not Less than today
then check its not a [ClosedDates] from the tbl_ClosedDates
Then if it’s a Sunday –1 day as the accounts lady doesn’t work on a Sunday

Their simple????

Attached file with sample variable data
BalanceDate.mdb

Ta
FAB1

I have been trying to construct a Query / If statement or should I use case statement to work out the actual payment date.First of all, this statement of yours is not clear...what EXACTLY are you wanting to do??

I looked at your database....from that and the information that you have posted in your thread, I am guessing that you are not ready to build any query yet. Maybe you could give a little more background on what your actual needs are??We have a special reduced rate that a client must prepay 12weeks before or sooner if a date is put in the [OverRideDate] fieldIf you could clarify this statement anymore, that would be helpful....[i]"before or sooner"??[i]Need help with this...more information.