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.
"rms" wrote:
[Quoted Text] > 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.
>
>
> "inbreda" wrote:
>
> > 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!
|