What I want:
I want report to show the # of orders for a user specified date in frmWhatDates based off of query qryTotal_Orders.
I'm having trouble getting a dcount expression to work in my report. Can anyone help my correct my syntax?
Main form: frmShipments
1. Click "preview report" command button
a. frmWhatDates appears
b. user enters mm/dd/yyyy and clicks "generates report" command button
c. report display # of orders for date entered in text box
Text boxes on report:
1. Date - Displays date entered: works successfully.
2. Total Orders count for date entered: (example: 327) #Error - NEED HELP
=DCount("[OrderDate]","qryTotal_Orders","[OrderDate] = " & [Forms].[frmWhatDates].[txtOrderDate] & "")
What am I doing wrong? Thanks in advance for any help.