Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

converting row into column

  
   Windows Help (Home) -> Microsoft Access RSS
Next:  Me.Name results in "Invalid procedure call o..  
Author Message
AShi

External


Since: Nov 26, 2008
Posts: 1



(Msg. 1) Posted: Wed Nov 26, 2008 7:45 am
Post subject: converting row into column
Archived from groups: microsoft>public>access (more info?)
I have a table with doctors' information Their addresses are linsted in
differnt rows i would like to create a row off addresses with one unique
record.

 >> Stay informed about: converting row into column 
Back to top
Login to vote
Beetle

External


Since: Nov 26, 2008
Posts: 9



(Msg. 2) Posted: Wed Nov 26, 2008 9:02 am
Post subject: RE: converting row into column
Archived from groups: per prev. post (more info?)
If you're saying that a doctor can have multiple adresses, and you want
to concantenate those addresses for display purposes, you can see this
link where you can download an example database by Duane Hookom;

[URL="http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16"]http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16[/URL]

 >> Stay informed about: converting row into column 
Back to top
Login to vote
Jeff Boyce

External


Since: Nov 26, 2008
Posts: 32



(Msg. 3) Posted: Wed Nov 26, 2008 9:04 am
Post subject: Re: converting row into column
Archived from groups: per prev. post (more info?)
To what end? What will having "one unique record" with multiple addresses
allow you to do?

Regards

Jeff Boyce
Microsoft Office/Access MVP


"AShi" wrote in message

>I have a table with doctors' information Their addresses are linsted in
> differnt rows i would like to create a row off addresses with one unique
> record.
 >> Stay informed about: converting row into column 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
How do I add a COLUMN to combo box - I have two combo boxes on a form. The first combo box gets info from tblPOTODO using a select query and the following code. SELECT tblPOTODO.PART_NO, tblPOTODO.NAME, tblPOTODO.MANUF1, tblPOTODO.MANUF1_PN, tblPOTODO.MANUF2, tblPOTODO.MANUF2_PN,..

VBA - Order by second column of combobox - I have a continuous form with column headers. The column headers are command buttons that you can click to order the form by that particular field. One of the fields is a combobox. It has two columns - one hidden bound column (autonumber) and one..

Query combobox unbound column - Does anyone know if it is possible to run an append query referencing a column in a combobox. In otherwords, my combobox is bound to column 0 - ID and column 1 is the name. I want to append it to another table as the name, not ID? Thanks in advance...

SQL - query moving column to a row - Hi. I have a table with fields: KEY;a;b I would like to create a query which will move the data from field "b" to next row: KEY;a KEY;b. Example: ID;phone1;phone2 => ID;phone1 ID;phone2 Is it possible? Best regards, Kamil

Sort / Filter Column Header Arrows Not Visible - The sort and filter arrows which used to be visible in tables and queries are now not visible. I can click on the right end of the field name and the Sort / Filter menu that displays when you click the arrow will appear. However, I cannot see which....
   Windows Help (Home) -> Microsoft Access All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]