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.

"AA Arens" <bartvandongen@gmail.com> wrote in message
news:1136039630.248341.274300@g44g2000cwa.googlegr oups.com...[color=blue]
> 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?[/color]

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

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