Items Not Showing up in Report

Hello,

I have a report in which I have several formulas, totals, percentages, etc.
Because of this I built the entire report in the "report header" section,
that way I don't have duplicate items, like I would if I put these formulas
in the "details" section. But this creates a problem, one of the items I
have in the report is an "Other Field". This "Other Field" is in the table,
and when information is data entered into the table, any misc information is
put in the "other" field. I want all of this "other" information in my
report, so I added this as an field on the report. But only 1 record shows
up, the rest of the records are not showing up.

If anyone can help me with why this would happen......I would really
appreciate it!

Thanks!

"that way I don't have duplicate items" and "I want all of this "other"
information in my report" are mutually exclusive. You might try put just the
Other information in the detail section or create a subreport of the Other
information and place it in the main report header section.

--
Duane Hookom
MS Access MVP


"Amber" wrote in message
...
Hello,

I have a report in which I have several formulas, totals, percentages,
etc.
Because of this I built the entire report in the "report header" section,
that way I don't have duplicate items, like I would if I put these
formulas
in the "details" section. But this creates a problem, one of the items I
have in the report is an "Other Field". This "Other Field" is in the
table,
and when information is data entered into the table, any misc information
is
put in the "other" field. I want all of this "other" information in my
report, so I added this as an field on the report. But only 1 record
shows
up, the rest of the records are not showing up.

If anyone can help me with why this would happen......I would really
appreciate it!

Thanks!