Hi and thanks in advance,
I am using DMin and DMax to calculate date fields in a form.
I need to use these calculated dates in another calculated field.
example:
=DMax("[B&MPayPeriodStartDate]","B&MPayPeriod"," [B&MSalesDate] >= [B&MPayPeriodStartDate] ")
This code calculates the starting date for a pay period and places it in a text box in my form.
example:
=DMin("[B&MPayPeriodEndDate]","B&MPayPeriod"," [B&MSalesDate] <= [B&MPayPeriodEndDate] ")
This code calculates the ending date for a pay period and places it in a text box in my form.
I now need to calculate the sum of sales between the two dates listed above. I've tried everything I can think of. And spent hours searching Access help and google but keep coming up blank. Any help will be greatly appreciated.
Thanks
Dale