Only get 1st record viewed in Report.

[AA Arens]

In "Repords" I used the "New" tool and made a Report in columns.
However, I only get the first record viewed, not the others. What's
going on?

Bart

Access 2003.

[Larry Linson]

"AA Arens" <ba***********@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...

In "Repords" I used the "New" tool and made a Report in columns.
However, I only get the first record viewed, not the others. What's
going on?

Sounds as though you included a WHERE clause in the RecordSource of the
Report, or opened the Report with a DoCmd.OpenReport and included a
WhereCondition argument (in some paths through the Command Button wizard,
this will be the variable stLinkCriteria).

Larry Linson
Microsoft Access MVP

[AA Arens]

I put the field beyond the margins. Problem solved. Thank you.