Ack! Please help.

[NoFedora]

My thanks in advance to anyone who can answer this question:

I have a query which is adding several fields of data together and then a report which is displaying the result of that query.

I have this set up and it works fine for two distinct queries.

However, a third query which looks the same as all the others except it adds a different set of numbers and which RUNS correctly when I run it, won't display the value, instead giving an ERR# message on the report.

Any reason why it would do this?

There is no mulitplication or dividing by zero just straight addition...

 

[Geneo]

How you by any chance in the report foot or the page footing.

The summing must be in the report foot.

 

[NoFedora]

No I am in the DETAIL section of the report.

The only other thing I notice is when I go to expression builder, under the database name, it shows TWO of my queries, but not the third one which is the one giving problems.

I have set up relationships between the queries and the fields in the ain tables and like I said two work but hte third qhich appears identical wont.

Grrrrr. If only I had taken Access classes when I had the chance.

 

[NoFedora]

Interesting enough if I look under Loaded Reports the third query I have there doesnt show, only the first two.