topdesk123
Registered User.
- Local time
- Today, 08:47
- Joined
- Mar 28, 2013
- Messages
- 52
Hello all!
I am creating a payments form in which I need to lookup how much a person has paid this month. I am using 2 date fields on my form to determine the first and last day of the month (firstday, lastday) I have a field on my form called PaymentsMadeToday (means as of today actually) with the following as the control source:
It produces #Name?. Without the date criteria, the amount will show up fine.
What am I missing? Thank you in advance.
I am creating a payments form in which I need to lookup how much a person has paid this month. I am using 2 date fields on my form to determine the first and last day of the month (firstday, lastday) I have a field on my form called PaymentsMadeToday (means as of today actually) with the following as the control source:
Code:
=DSum("Amount","paymentT","LoanID=" & [LoanID] And [PaidDate] Between [firstday] And [lastday])
What am I missing? Thank you in advance.