field limit in report (from query)

[_Bigred]

Access 2000

Is there a limit to the number of query fields you can use in a report?

When trying to use a query (that has 20 fields), in a report.

I tried to create a report using the report wizard and it errored stating
that I couldn't import all the fields into the report?

What is the limit of fields from a query being used in a report? Is there a
way to get around this?

TIA,
_Bigred

 

[Rick Brandt]

Access 2000

Is there a limit to the number of query fields you can use in a
report?
When trying to use a query (that has 20 fields), in a report.

I tried to create a report using the report wizard and it errored
stating that I couldn't import all the fields into the report?

What is the limit of fields from a query being used in a report? Is
there a way to get around this?

The limit was more likely with the wizard. Just build the report manually.

 

[_Bigred]

I'll check that out, and post back.
Thanks,
_Bigred

 

[_Bigred]

Thanks Rick it worked like a charm. But now I have a new problem, the
report has 32 total fields for each record.
I set it up to prompt for a players First and Last Name as criteria, which
works great.

The repBATTINGfielding is based off qryBATTINGfielding (the
qryBATTINGfielding is based on fields from 3 different tables tblMASTER,
tblBATTING, tblFIELDING). When I obtained this db it already had
relationship setup in it.

when the report opens and prompts me for the criteria I punch it in, and get
the records displayed that I want but for some reason I'm getting 4 of each
record on my report.

E.G I wanted the BATTINGfielding statistics for Ben Sheets Career, it
returns the on the report (four) of the same record for 2004, (four) of the
same record for 2003 and so on??

Where should I start looking for the problem? I know when I added all (3)
tables listed above in the query it had BOLD field names in each table
(while in query design view). I can provide additional information if it is
helpful.

Thanks,
_Bigred

 

[Duane Hookom]

Your query is the issue. I think you might not be joining all the
appropriate fields. You might have four records selected from a table where
you expect one record.