search for field names in report from crosstab

[tonyrulesyall]

I am using Access XP for my project.

I put together a crosstab query. There are totals for many types
of groups.

For example:

a101 a108 a119 etc.
621.23 111.65 25.12

I would like to get my textbox in a report to be populated so
the first page has "a101" in it, the next page has "a108",
and the third page has "a109".

It is possible that the next time I run the report, I could have
totals for "a102", "a108" and "a120" (but not include "a101"
and/or "a119").

Is there a way to get these unique field names one page after the
other, without doing a loop through all the combinations, just
to find a match? There are many combinations, so this would take
a long time.

 

[Larry Linson]

If you would carefully re-read this, forcing yourself to approach
understanding it with NO knowledge of what you are doing, no database in
front of you, and totally relying on the information you have provided, I
suspect you will realize why you haven't gotten any answers.

You did state what version of Access you're using, and That's Good.

You didn't explain what data you have, how you've laid it out in tables,
what relationships are involved, if any, etc., and That's Bad.

The report you describe does not sound like any crosstab report I've ever
dealt with, so I don't follow what you want, and That's Bad.

I'm surely not the most knowledgeable person about Crosstab reports, but I
suspect I am not the only one to be at pretty much a total loss to be able
to help. The questions that get the best answers are ones where the
information given is detailed, but precise and concise. Often it is
necessary to tell us what you really have (not, I have an A109) and what
you're trying to accomplish, because often the correct answer is not
performed _how_ the original poster decided it should be performed.

Larry Linson
Microsoft Office Access MVP