Show all records for individual in columns (1 Viewer)

[theseus]

I am trying to group calls made to individuals in distinct columns. Each record has the individual's identifier and details about the call. Can I create a report that shows me the individual then the details about the calls with each column being a new call?

Identifier------> Call 1-----> Call 2-----Call 3 ==== and so on

Thanks for pointing me in the right direction.

 

[theDBguy]

Hi. Try using a Crosstab query to see if it can do what you want.

 

[June7]

This is denormalization of data, often done with a CROSSTAB query. Building a stable report based on CROSSTAB is very tricky.

Another method would involve VBA code and writing data to a 'temp' table.

There are only 2 fields? What kind of data is 'details'?

How many calls could an individual have? Like a table, a query is limited to 255 fields.

 

[Uncle Gizmo]

See:-

Display Field Data Horizontally - Nifty Access

More info on Nifty Access Website HERE:-
Transform, Concatenate Examples

The sample file is available for Free. Contact me and I will explain how you can obtain the sample file for free..

 

[theseus]

The call details are text data and some individuals have 6 or 7 calls.

 

[theDBguy]

The call details are text data and some individuals have 6 or 7 calls.

The normal approach for displaying this on a report is by grouping the data by individuals. What happens if someone has more calls than can be displayed within the width of the report?

 

[June7]

I just remembered another approach. Uses Columns formatting in report design. Set a grouping on individual and specify 6 columns, snake across then down. Set report GrpKeepTogether property to PerColumn. Set group header NewRowOrCol property to Before&After.