Begin Date & End Date

[S Jackson]

I have a form that asks the user to select a begdate and enddate before
previewing the rptNewCases report.

In the query that the report is based on, I have selected two tables. Under
the AssignDate field, I have the following expression:

Between [Forms]![fdlgRptSingle]![begdate] And
[Forms]![fdlgRptSingle]![enddate]

When the user enters the dates and selects Print/Preview the following error
occurs:

The expression is typed incorrectly, or it is too complex to be evaluated.
For example, a numeric expression may contain too many complicated elements.
Try simplifying the expression by assigning parts of the expression to
variables.


What is going wrong here? I don't know how to "simplify" the expression.

TIA

S. Jackson

 

[S Jackson]

I just tried something - I deleted one of the tables in my query and now the
query only contains one table. The expression works now, but this is not
satisfactory. I need the other table in my query as it contains a field
that I have assigned a "IsNull" expression to.

 

[jfp]

without seeing the SQL we cannot comment further.
Access can be surprisingly weak with queries -- but, then again, even
"simple" queries can be surprisingly complex to implement. One of the
basic design philosophies of Access seems to be:
Run a query whose data source is a query whose ...
SO -- try running the report off Q2 whose input is Q1 linked to Table B
where Q1 is based only on Table A (and contains your criterion).
-=-=-=

I just tried something - I deleted one of the tables in my query and now the
query only contains one table. The expression works now, but this is not
satisfactory. I need the other table in my query as it contains a field
that I have assigned a "IsNull" expression to.

I have a form that asks the user to select a begdate and enddate before
previewing the rptNewCases report.

In the query that the report is based on, I have selected two tables. Under
the AssignDate field, I have the following expression:

Between [Forms]![fdlgRptSingle]![begdate] And
[Forms]![fdlgRptSingle]![enddate]

When the user enters the dates and selects Print/Preview the following error
occurs:

The expression is typed incorrectly, or it is too complex to be evaluated.
For example, a numeric expression may contain too many complicated elements.
Try simplifying the expression by assigning parts of the expression to
variables.


What is going wrong here? I don't know how to "simplify" the expression.

TIA

S. Jackson