Help!

access 2003 query report "# error"

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Reports RSS
Next:  linked table manager - help 13  
Author Message
marfi95
External


Since: Mar 25, 2007
Posts: 4



PostPosted: Mon Mar 26, 2007 10:56 am    Post subject: access 2003 query report "# error"
Archived from groups: microsoft>public>access>reports (more info?)

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
Back to top
Al Campagna
External


Since: Jan 01, 2007
Posts: 378



PostPosted: Mon Mar 26, 2007 4:03 pm    Post subject: Re: access 2003 query report "# error" [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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."

"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 !
> Mark
>
Back to top
FonsPonsio
External


Since: Mar 27, 2007
Posts: 2



PostPosted: Tue Mar 27, 2007 10:50 pm    Post subject: RE: access 2003 query report "# error" [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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

"marfi95" wrote:

> 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
>
>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Reports All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum