Switching Fields into Records

  • Thread starter Thread starter Prohock
  • Start date Start date
P

Prohock

In a table I have one record that has the following fields [Principal] [VP1]
[VP2]. How can I get these fields from this one record source to be listed in
one field category [Admin] to be used with a combo box list. Right now my
combo box displays the choices in a horizontal line and I would like them to
be displayed vertically, thus needing all my fields to be grouped into new
records under one new field called [Admin]
 
You seem to need an Admin table:
TblAdmin
AdminID
Admin (Principal, VP1 and VP2)

You can then use TblAdmin as the row source of your combobox.

Steve
(e-mail address removed)
 
How do I get the table to auto populate the TblAdmin.Admin field as new
records with the fields (each adminstrators name) I have from the one record
sourch stored in table TblSchoolInfo?

Steve said:
You seem to need an Admin table:
TblAdmin
AdminID
Admin (Principal, VP1 and VP2)

You can then use TblAdmin as the row source of your combobox.

Steve
(e-mail address removed)


Prohock said:
In a table I have one record that has the following fields [Principal]
[VP1]
[VP2]. How can I get these fields from this one record source to be listed
in
one field category [Admin] to be used with a combo box list. Right now my
combo box displays the choices in a horizontal line and I would like them
to
be displayed vertically, thus needing all my fields to be grouped into new
records under one new field called [Admin]
Click to expand...


.
Click to expand...
 
If you are stuck with the current design then you can use a union query to get
the values you want. UNION queries can only be built in SQL view and not in
query design view.

SELECT Principal, "Principal" as Position
FROM tblSchoolInfo
WHERE Principal is Not NULL
UNION
SELECT vp1, "VP1" as Position
FROM tblSchoolInfo
WHERE Principal is Not NULL
UNION
SELECT vp2, "VP2" as Position
FROM tblSchoolInfo
WHERE Principal is Not NULL

You might be better off adding a table as Steve suggested. You could populate
it using a modification of the above UNION query that contained the school
identifier.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
How do I get the table to auto populate the TblAdmin.Admin field as new
records with the fields (each adminstrators name) I have from the one record
sourch stored in table TblSchoolInfo?

Steve said:
You seem to need an Admin table:
TblAdmin
AdminID
Admin (Principal, VP1 and VP2)

You can then use TblAdmin as the row source of your combobox.

Steve
(e-mail address removed)


Prohock said:
In a table I have one record that has the following fields [Principal]
[VP1]
[VP2]. How can I get these fields from this one record source to be listed
in
one field category [Admin] to be used with a combo box list. Right now my
combo box displays the choices in a horizontal line and I would like them
to
be displayed vertically, thus needing all my fields to be grouped into new
records under one new field called [Admin]
Click to expand...

.
Click to expand...
Click to expand...
 
Post all the fields from TblSchoolInfo and we will go from there.

Steve


Prohock said:
How do I get the table to auto populate the TblAdmin.Admin field as new
records with the fields (each adminstrators name) I have from the one
record
sourch stored in table TblSchoolInfo?

Steve said:
You seem to need an Admin table:
TblAdmin
AdminID
Admin (Principal, VP1 and VP2)

You can then use TblAdmin as the row source of your combobox.

Steve
(e-mail address removed)


Prohock said:
In a table I have one record that has the following fields [Principal]
[VP1]
[VP2]. How can I get these fields from this one record source to be
listed
in
one field category [Admin] to be used with a combo box list. Right now
my
combo box displays the choices in a horizontal line and I would like
them
to
be displayed vertically, thus needing all my fields to be grouped into
new
records under one new field called [Admin]
Click to expand...


.
Click to expand...
Click to expand...
 
Thanks! It works perfectly now.

Steve said:
Post all the fields from TblSchoolInfo and we will go from there.

Steve


Prohock said:
How do I get the table to auto populate the TblAdmin.Admin field as new
records with the fields (each adminstrators name) I have from the one
record
sourch stored in table TblSchoolInfo?

Steve said:
You seem to need an Admin table:
TblAdmin
AdminID
Admin (Principal, VP1 and VP2)

You can then use TblAdmin as the row source of your combobox.

Steve
(e-mail address removed)


In a table I have one record that has the following fields [Principal]
[VP1]
[VP2]. How can I get these fields from this one record source to be
listed
in
one field category [Admin] to be used with a combo box list. Right now
my
combo box displays the choices in a horizontal line and I would like
them
to
be displayed vertically, thus needing all my fields to be grouped into
new
records under one new field called [Admin]


.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top