This expression is typed incorrectly, or is too complex

[Guest]

Hi,

I am trying to create a report but get the error "This expression is typed
incorrectly, or is too complex..."

I have tried numerous approaches - adapting existing reports, starting
afresh, putting the expression in a query and referencing the query...

I finally got a query to work and return the data that I wanted it to
return. It works even now, but if I create a report and just refer it to the
query I get the same message again. The report would only have three fields
and up to about ten records, and the expression doesn't seem too complex for
the query - Ahhhh!!!!

I've googled this and there seem to be lots of people suffering the same
problem but no solutions out there.

Please help!

 

[Guest]

One solution would be to

change the query to a make table query and run it once and create a
temporary table.
Create the report based on the temporary table.
Then change query to an append query to use in a macro as outlined below to
creat the report with updated data

create a macro to:

open the temporary table,
select all records,
delete all records
close temporary table
Run append query
Run report based on temporary table.

 

[Guest]

Thankyou rms - sometimes it's not possible to see the wood for the trees -
you've saved me a lot of hair pulling and it is much appreciated.