I have a form called Totals which has 2 text boxes.
One you enter a ID number. The textbox is called txtPS.
The other has my Dcount code. Called txttotals.
Code:
=DCount("[APPROVED]","tbl_sales","Seller =" & Forms!QuickStats!txtSeller And [APPROVED]="Approved" And [DATE REFERRED] Between DateSerial(Year(Date()),Month(Date()),1) And Now())
My code is not working I keep getting #Name?, any help would be greatly appreciated
One you enter a ID number. The textbox is called txtPS.
The other has my Dcount code. Called txttotals.
Code:
=DCount("[APPROVED]","tbl_sales","Seller =" & Forms!QuickStats!txtSeller And [APPROVED]="Approved" And [DATE REFERRED] Between DateSerial(Year(Date()),Month(Date()),1) And Now())
My code is not working I keep getting #Name?, any help would be greatly appreciated