Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  How to display multiple entries into columns?

Author  Topic  kamen99 Starting Member 3 Posts Posted - 2002-07-11 : 10:49:17 In MS Access, how can I display the field with repeated entries in columns? For example : A file with the following fields : field 1 : name field 2 : year field 3 : rate file structure like this : Name Year Rate Peter 1999 B Peter 2000 A Peter 2001 A May 2000 A May 2001 A Desired query output will be name Year1 Rate1 Year2 Rate2 Year3 Rate3 Peter 1999 B 2000 A 2001 A May 2000 A 2001 A And one more condition, the number of entries for each person may vary from 0 to 7. Any suggestion on how to do it? Your assistance will be appreciated. Regards Kamen