"[MyDate] Between #" & Format(Me![BeginDate], "mm/dd/yy") & "# and #"
& Format(Me![EndDate], "mm/dd/yy") & "# AND [DC] = "'" & Me![DCselect]
& "'"
When running the code above I get the following error:
"Microsoft Access can't find the field "|" referred to in your
expression
The code works fine when just using the "date" filter, but falls apart
when the "DC" filter is included.
Can anyone offer any suggestions as to how to correct the error or
alternatives to the code above?
Regards,
Nathan
BTW I have reposted this code which is related to another thread as I
require urgent assistance. This problem is holding back a project
which must be completed in 2 days time.