access 2003 query report "# error"

  • Thread starter Thread starter marfi95
  • Start date Start date
M

marfi95

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 !
Mark
 
marfi,
Make sure that the field name on the report is not the name of any item in the
calculation.
Ex. Name = Price
= Price * Qty (will cause #error... Price name and Price operative)

Name = LineTotal
=Price*Qty (OK)
If this doesn't do it... please send more info on your query field and the associated
field on the report.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Hi Mark.
Usually when I get that error I have a naming conflict, check the name of
the field in your report, Is this name also the name of one of your data
fields? or is it a reserved name.
Hope this helps.
Fons
 
Back
Top