Make sure that the field name on the report is not the name of any item in the
Ex. Name = Price
= Price * Qty (will cause #error... Price name and Price operative)
Name = LineTotal
If this doesn't do it... please send more info on your query field and the associated
field on the report.
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
"Find a job that you love, and you'll never work a day in your life."
"marfi95" wrote in message
> Hi all,
> I'm not sure what else to look at here.
> I have a rather complex query that I am using to underly a report.
> All the data in the query is correct when I run the query with the
> parameters. When I run the report using the same parameters,
> everything is fine except one column shows up as # Error.
> Not sure why it runs fine in the query, but the report column shows up
> as an error.
> I don't know if this matters, but the query does a lot of grouping and
> joins a separate "Totals Query" as a column (to get a total of all
> records) so I can calculate a percentage of the total for each group.
> It happens to be the column calculating this percentage that errors on
> the report. It does work fine however in the query itself.
> Any ideas ?
> Thanks !