error viewing report

[berladybug]

I get an error message "the expression is typed incorrectly, or it is too
complex to be evaluated..." when pulling a report. I think it has something
to do with the dates but I do not know what. I was working until I tried to
pull reports for October. The parameters ask for a start date and an end date
for the report. Date field is as follows:
Data Type: Date/Time
Format: mm/dd/yyy
Input Mask: 00/00/0000:0:_
Any help is greatly appreciated.

 

[Jeff Boyce]

The key in your error message is "the expression"...

Unless you show us the expression, we can only guess what might be
"incorrect... or ... too complex..."

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[berladybug]

These are the expressions
On the query for the report
Between [Enter Start Date] And [Enter End Date]

[Enter Case Manager Name]

On the report
Report header section
="Report Period From" & " " & [Enter Start Date] & " " & "Through" & " " &
[Enter End Date]

Name header section
=[FName] & " " & [LName]

Name footer section
=Sum([Contact Hours])

=Sum([Total # Follow Ups])


Report footer section
=Sum([Contact Hours])

=Sum([Total # Follow Ups])

 

[berladybug]

Also the query will pull the records but the report will not.

 

[Jeff Boyce]

Usually, the expression being referred to is the SQL statement of the query.
Would you please post that as well?

Regards

Jeff Boyce
Microsoft Office/Access MVP

These are the expressions
On the query for the report
Between [Enter Start Date] And [Enter End Date]

[Enter Case Manager Name]

On the report
Report header section
="Report Period From" & " " & [Enter Start Date] & " " & "Through" & " " &
[Enter End Date]

Name header section
=[FName] & " " & [LName]

Name footer section
=Sum([Contact Hours])

=Sum([Total # Follow Ups])


Report footer section
=Sum([Contact Hours])

=Sum([Total # Follow Ups])

The key in your error message is "the expression"...

Unless you show us the expression, we can only guess what might be
"incorrect... or ... too complex..."

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

If the query works (returns the correct rows) but a report based on the
query does not, I'd look at whether the report has any filters applied
(check the report design view/properties).

Also, how is the report being "run"? Are you opening the database window,
going to the Reports tab and opening the report, or is there a
form/code/macro/other...?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[berladybug]

There are no filters on the reports only the parameters that are in the query.
This is on the query in the criteria section for 2 different fields:
Between [Enter Start Date] And [Enter End Date]

[Enter Case Manager Name]

I did not put in any SQL statements.

The report is being run from the database window by me and from the
switchboard by case managers. Neither of which works. But the query does work
(pull ther records)

 

[Jeff Boyce]

When I get a report that doesn't work (and the query does), and I've tried
the items we've discussed, and it still isn't working, I start over. That
is, I create a totally new report, from scratch, and see if THAT report has
the same problem.

Regards

Jeff Boyce
Microsoft Office/Access MVP

There are no filters on the reports only the parameters that are in the
query.
This is on the query in the criteria section for 2 different fields:
Between [Enter Start Date] And [Enter End Date]

[Enter Case Manager Name]

I did not put in any SQL statements.

The report is being run from the database window by me and from the
switchboard by case managers. Neither of which works. But the query does
work
(pull ther records)

If the query works (returns the correct rows) but a report based on the
query does not, I'd look at whether the report has any filters applied
(check the report design view/properties).

Also, how is the report being "run"? Are you opening the database
window,
going to the Reports tab and opening the report, or is there a
form/code/macro/other...?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[berladybug]

Thanks, I will try a new report and see what happens.

When I get a report that doesn't work (and the query does), and I've tried
the items we've discussed, and it still isn't working, I start over. That
is, I create a totally new report, from scratch, and see if THAT report has
the same problem.

Regards

Jeff Boyce
Microsoft Office/Access MVP

There are no filters on the reports only the parameters that are in the
query.
This is on the query in the criteria section for 2 different fields:
Between [Enter Start Date] And [Enter End Date]

[Enter Case Manager Name]

I did not put in any SQL statements.

The report is being run from the database window by me and from the
switchboard by case managers. Neither of which works. But the query does
work
(pull ther records)

If the query works (returns the correct rows) but a report based on the
query does not, I'd look at whether the report has any filters applied
(check the report design view/properties).

Also, how is the report being "run"? Are you opening the database
window,
going to the Reports tab and opening the report, or is there a
form/code/macro/other...?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Also the query will pull the records but the report will not.

:

The key in your error message is "the expression"...

Unless you show us the expression, we can only guess what might be
"incorrect... or ... too complex..."

Regards

Jeff Boyce
Microsoft Office/Access MVP

I get an error message "the expression is typed incorrectly, or it is
too
complex to be evaluated..." when pulling a report. I think it has
something
to do with the dates but I do not know what. I was working until I
tried
to
pull reports for October. The parameters ask for a start date and an
end
date
for the report. Date field is as follows:
Data Type: Date/Time
Format: mm/dd/yyy
Input Mask: 00/00/0000:0:_
Any help is greatly appreciated.