Displaying field values vertically (1 Viewer)

vgillis

New member
Local time
Today, 02:27
Joined
Mar 5, 2013
Messages
3
Hi all..I don't know if this is possible or not..but any help would be so appreciated.

This is a scaled down version of my problem..

Two tables..

Person
id number
name

activity
id number
activity

A person can have multiple activities.

Instead of the report printing a row for each activity like this..
id number, name, activity 1
id, number, name, activity 2

I would like it to print like this..
id number, name, activity 1, activity 2, activity 3...ect..

The number of activities a person can have varies..

Does anyone have any idea is this is possible and how to do it?

Thanks.
Veronica
 

kevlray

Registered User.
Local time
Today, 02:27
Joined
Apr 5, 2010
Messages
1,046
I do not know if you have come up with solution, but I have a question.

Are Activty 1 and Activity 2 (and so forth) different fields or they the same field with different values? It makes a difference how you might be able to do this.
 

CJ_London

Super Moderator
Staff member
Local time
Today, 09:27
Joined
Feb 19, 2013
Messages
16,553
Sounds like you need to use a crosstab query - you'll find it in the query designer.

Having said that, it does not look like your two tables can be linked - I would expect to see a 3 field table along these lines

WhosActivity
id number
PersonID
ActivityID
 

Users who are viewing this thread

Top Bottom