Can each record be a column?

[smaumau]

I would like to create a report like the following:

Record1: Record2: Record3: Total:
Field 1:
Field 2:
Field 3:
Field 4:
Field 5:

This is the opposite of standard reports and I can't seem to find a way to do this.

 

[Banana]

Look up on crosstab query. This will do what you want.

 

[SamDeMan]

you might need to first create a union query and then a crosstab query.