Report Question

[Tom]

This is related to an earlier post entitled "Text in Query/Numbers in
Report"

Brief recap - report has a query as a record source. The query shows
the correct data, the report translating the text in one field into
numbers. The field in question uses a NZ function. They query is an
aggregate query with the field in question using the First operator.
After additional troubleshooting, I have found the following...

1. When the report has a group header on the field and the field is in
that group header, the report different information than the underlying
query (for that field).

2. When the report has a group header on the field and the field is in
the detail section, the report the same information as the underlying
query (for that field).

3. When the report does not have a group header on the field and the
field is in the detail section, the report the same information as the
underlying query (for that field).

Scenarios 2 and 3 are as you would expect. Scenario 1 is what is
driving me nuts.

I have tried SaveAsText, LoadFromText for the report - no effects.

Any ideas?

Thanks

[Larry Linson]

The devil is probably in the details, but just as a guess, the Totals Query
you are using likely relies on some ordering of the data, but ordering of
the data in Reports relies on the Sorting and Grouping properties of the
Report -- perhaps there is some conflict between the two.

To further diagnose the problem, perhaps you could convert the Totals Query
to a Make Table Query, then try using the resulting table as the Record
Source of the Report. (I find temporary Tables are often useful in
debugging, though I try to avoid using them in production applications,
usually can avoid it.) This, however, might turn out to be one of those
instances where temporary tables are appropriate in production.

Larry Linson
Microsoft Access MVP
"Tom" <rt*****@swbell.net> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

This is related to an earlier post entitled "Text in Query/Numbers in
Report"

Brief recap - report has a query as a record source. The query shows
the correct data, the report translating the text in one field into
numbers. The field in question uses a NZ function. They query is an
aggregate query with the field in question using the First operator.
After additional troubleshooting, I have found the following...

1. When the report has a group header on the field and the field is in
that group header, the report different information than the underlying
query (for that field).

2. When the report has a group header on the field and the field is in
the detail section, the report the same information as the underlying
query (for that field).

3. When the report does not have a group header on the field and the
field is in the detail section, the report the same information as the
underlying query (for that field).

Scenarios 2 and 3 are as you would expect. Scenario 1 is what is
driving me nuts.

I have tried SaveAsText, LoadFromText for the report - no effects.

Any ideas?

Thanks

[Tom]

That's the ticket - thanks. Someday I'll go back to figure out why it
works. For now its good enough that it works.

Tom