Wanting Different Lists In The Same Column

[jigsaw1980]

Hi There,

I am looking to add 3 or more different list values into the same column on the same table.

All lists are stored in seperate tables within the same database.

Can this be done.

Please see attached screen shot?

Thanks,
Mark

 

[Mihail]

The main information should be about how you wish to join this fields into a single one.

 

[Galaxiom]

Such a request almost invariably indicates that the database is incorrectly structured. Post a description of your tables and we will tell you how to restructure your data.

 

[jigsaw1980]

Hi Folks,

Thanks for your reply. Please note I am not seeking to create a database with tables that are joined.

The table in question is to be imported across into an Excel Sheet, where users create other entities.

So my thinking was for the data to appear as follows going from left to right

Field Label , Value (Some fields will be free text, some dates, some a selection from a list box)

Am I coming at this from completely the wrong angle?

Thanks,
Mark

 

[jdraw]

You might wish to determine why you have Access and Excel for this application. If you don't want joined tables, and joined tables are recommended, why not stay with excel?

For the reader to understand your situation, I think you should tell us WHAT you are trying to do in plain English business terms. Forget Access and Excel and describe WHAT you want to achieve, and then let the readers comment/advise.

 

[jigsaw1980]

Its quite a customised project that I am trying. Just before I go into anymore detail and send everyone to sleep maybe someone could advise on how to do the following (If possible)

When importing a table from Access to Excel, is there any way to have the Column Headings of the Access Database on the side of the Excel Sheet.

So for example

Access View
Date Staff Member Date Of Birth Phone Number

When Imported in Excel
Date
Staff Member
Date Of Birth
Phone Number

Thanks Again.

 

[Mihail]

I don't think so. Not with the already built in facilities for import/export either for Access or for Excel. By using full (hard) VBA code is possible.
But, if I remember well, Excel has a functionality to transpose a selection (I think that is under Paste Special tool). So, should be a baby task to do this in Excel. If you will create a macro, this will be automatically done after import.