Report: Add info from a table ans a query

  • Thread starter Thread starter Tim S
  • Start date Start date
T

Tim S

I have a report that 99.% of the fields are IF statements
that if certain criteria is met the data comes from a
table otherwise it is blank.
at the end of the report I want to add data from a query.
The query is plain old average data.
I have tried Control source and entered the query info.
specifically
=[average ratio qry]![AvgOfSR026]

I run the report and get a parameter query dialog box (i
have no parameters in the query)
the report then just shows Error.
What am I doing wrong???
Thanks
 
The way I read your description is that the query data is
not part of the source for your report. In that case you
should place a subreport at the end of your report and
make the query the source of your subreport.
Hope th is helps.
Fons
 
Back
Top