|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 1st, 2009, 07:11 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Report List with Commas
Hello,
In my database, I have a table with Company Name, First name, Last name. Example Data.. Shawn's Store Shawn Doe Shawn's Store Jane Doe Shawn's Store Peter Paul Microsofts Store Harry Clein Microsofts Store Count Johns Microsofts Store Mary Smith I would like to create a report that would group on Company name, and then list the First name then Last name followed by a comma and continue listing the names horizontally like so.. Shawn's Store Shawn Doe, Jane Doe, Peter Paul Microsofts Store Harry Clein, Count Johns, Mary Smith is this possible. everything i try gives me a list vertically and isn't what i want. Any help would be greatly appreciated. 
|
|
#2
May 1st, 2009, 08:07 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Report List with Commas
going horizontal is not database centric...which is why you are having a hard
time finding a technique. you could probably try a crosstab query - - and then use that as a record source for a report....I haven't ever tried this though.... "S" wrote: Hello, In my database, I have a table with Company Name, First name, Last name. Example Data.. Shawn's Store Shawn Doe Shawn's Store Jane Doe Shawn's Store Peter Paul Microsofts Store Harry Clein Microsofts Store Count Johns Microsofts Store Mary Smith I would like to create a report that would group on Company name, and then list the First name then Last name followed by a comma and continue listing the names horizontally like so.. Shawn's Store Shawn Doe, Jane Doe, Peter Paul Microsofts Store Harry Clein, Count Johns, Mary Smith is this possible. everything i try gives me a list vertically and isn't what i want. Any help would be greatly appreciated.
|
|
#3
May 1st, 2009, 09:12 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Report List with Commas
See Duane Hookom's sample at
http://www.rogersaccesslibrary.com/f...sts.asp?TID=16 John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County S wrote: Hello, In my database, I have a table with Company Name, First name, Last name. Example Data.. Shawn's Store Shawn Doe Shawn's Store Jane Doe Shawn's Store Peter Paul Microsofts Store Harry Clein Microsofts Store Count Johns Microsofts Store Mary Smith I would like to create a report that would group on Company name, and then list the First name then Last name followed by a comma and continue listing the names horizontally like so.. Shawn's Store Shawn Doe, Jane Doe, Peter Paul Microsofts Store Harry Clein, Count Johns, Mary Smith is this possible. everything i try gives me a list vertically and isn't what i want. Any help would be greatly appreciated.
|
|
#4
May 2nd, 2009, 12:11 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Report List with Commas
The example is what i need however I'm having trouble converting the code for
my database. "John Spencer MVP" wrote: See Duane Hookom's sample at http://www.rogersaccesslibrary.com/f...sts.asp?TID=16 John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County S wrote: Hello, In my database, I have a table with Company Name, First name, Last name. Example Data.. Shawn's Store Shawn Doe Shawn's Store Jane Doe Shawn's Store Peter Paul Microsofts Store Harry Clein Microsofts Store Count Johns Microsofts Store Mary Smith I would like to create a report that would group on Company name, and then list the First name then Last name followed by a comma and continue listing the names horizontally like so.. Shawn's Store Shawn Doe, Jane Doe, Peter Paul Microsofts Store Harry Clein, Count Johns, Mary Smith is this possible. everything i try gives me a list vertically and isn't what i want. Any help would be greatly appreciated.
|
|
#5
May 2nd, 2009, 12:57 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Report List with Commas
Did you read the comments in the code about commenting out some lines
and commenting in some other lines? Comment out - add an ' at the beginning of the line Uncomment a line - remove the ' at the beginning of the line '================================================= === John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County '================================================= === S wrote: The example is what i need however I'm having trouble converting the code for my database. "John Spencer MVP" wrote: See Duane Hookom's sample at http://www.rogersaccesslibrary.com/f...sts.asp?TID=16 John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County S wrote: Hello, In my database, I have a table with Company Name, First name, Last name. Example Data.. Shawn's Store Shawn Doe Shawn's Store Jane Doe Shawn's Store Peter Paul Microsofts Store Harry Clein Microsofts Store Count Johns Microsofts Store Mary Smith I would like to create a report that would group on Company name, and then list the First name then Last name followed by a comma and continue listing the names horizontally like so.. Shawn's Store Shawn Doe, Jane Doe, Peter Paul Microsofts Store Harry Clein, Count Johns, Mary Smith is this possible. everything i try gives me a list vertically and isn't what i want. Any help would be greatly appreciated.
|
|
#6
May 2nd, 2009, 10:55 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Report List with Commas
I got the code to work!
The only thing I'm wondering now...i scan the list be put into alphabetical order by last name? "John Spencer" wrote: Did you read the comments in the code about commenting out some lines and commenting in some other lines? Comment out - add an ' at the beginning of the line Uncomment a line - remove the ' at the beginning of the line '================================================= === John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County '================================================= === S wrote: The example is what i need however I'm having trouble converting the code for my database. "John Spencer MVP" wrote: See Duane Hookom's sample at http://www.rogersaccesslibrary.com/f...sts.asp?TID=16 John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County S wrote: Hello, In my database, I have a table with Company Name, First name, Last name. Example Data.. Shawn's Store Shawn Doe Shawn's Store Jane Doe Shawn's Store Peter Paul Microsofts Store Harry Clein Microsofts Store Count Johns Microsofts Store Mary Smith I would like to create a report that would group on Company name, and then list the First name then Last name followed by a comma and continue listing the names horizontally like so.. Shawn's Store Shawn Doe, Jane Doe, Peter Paul Microsofts Store Harry Clein, Count Johns, Mary Smith is this possible. everything i try gives me a list vertically and isn't what i want. Any help would be greatly appreciated.
|
|
#7
May 2nd, 2009, 11:04 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Report List with Commas
silly question... just put order by in code.
all set. thanks everyone! "S" wrote: I got the code to work! The only thing I'm wondering now...i scan the list be put into alphabetical order by last name? "John Spencer" wrote: Did you read the comments in the code about commenting out some lines and commenting in some other lines? Comment out - add an ' at the beginning of the line Uncomment a line - remove the ' at the beginning of the line '================================================= === John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County '================================================= === S wrote: The example is what i need however I'm having trouble converting the code for my database. "John Spencer MVP" wrote: See Duane Hookom's sample at http://www.rogersaccesslibrary.com/f...sts.asp?TID=16 John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County S wrote: Hello, In my database, I have a table with Company Name, First name, Last name. Example Data.. Shawn's Store Shawn Doe Shawn's Store Jane Doe Shawn's Store Peter Paul Microsofts Store Harry Clein Microsofts Store Count Johns Microsofts Store Mary Smith I would like to create a report that would group on Company name, and then list the First name then Last name followed by a comma and continue listing the names horizontally like so.. Shawn's Store Shawn Doe, Jane Doe, Peter Paul Microsofts Store Harry Clein, Count Johns, Mary Smith is this possible. everything i try gives me a list vertically and isn't what i want. Any help would be greatly appreciated.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
