jzacharias
Registered User.
- Local time
- Today, 00:30
- Joined
- Sep 13, 2010
- Messages
- 137
How could I have a text box in a subform keep a sum of tickets written for a year to date (October 01-September 30)?
I received an error in the text box.
=DSum("Traffic", "tbl_Tickets", "[Ticket_Date] Between DateSerial(Year([B][COLOR=red]Date()[/COLOR][/B])-1, 10, 1) And DateSerial(Year([COLOR=red][B]Date()[/B][/COLOR]), 9, 30)")
=DSum("Traffic", "tbl_Tickets", "[Ticket_Date] Between DateSerial(Year([COLOR=black]Date()[/COLOR])-1, 10, 1) And DateSerial(Year([COLOR=black]Date()[/COLOR]), 9, 30) [B][COLOR=red]And [Officer]=" & Chr(34) & [Officer] & Chr(34)[/COLOR][/B]),0)")