Query Field Name Snytax Error

[Vol71]

I have an input form named "Report Center" that runs a query that generates reports, and I am trying to get the query to filter the Issue date by a date range based on 2 text boxes named "Beginning Date" and "Ending Date". I have multiple ways to filter my results on the input form that need to be independent from one another. My understanding is that I have to add an additional field with the field name surronded in [...]. Whenever I try to enter the code listed below, I get a message that my expression has invalid syntax and I may have entered a comma without a preceding value or identifier.


[Issue Date]= Between Nz([forms]![Report Center].[Beginning_Date],#1/1/1900#) And Nz([forms]![Report Center].[Ending Date],#1/1/2100#) Or[Issue Date] = Between Nz([forms]![Report Center].[Beginning_Date],#1/1/1900#) And Nz([forms]![Report Center].[Ending Date],#1/1/2100#) Is Null

Thanks

[pbaldy]

You don't want the =, and I'm not sure what the second bit is supposed to accomplish.

[Vol71]

This issue somehow fixed itself. The date range code had to be placed on the criteria line.