Can you join a value to a column heading?

[theseandavis]

Is it possible to join a value to a column heading?

Ie, I want to join all entries that are in the month January to the
column labeled '1', except that the column labeled '1' has no entiries
within it that are 1.

 

[Rick B]

We need some more information here. Are you talking about a form or a
report?

What is the layout of the data? It sounds like you are trying to build a
cross-tab.

More details please.

 

[theseandavis]

Unfortunately Im pretty new at this, but I'll try and provide as much
info as possilble:

I have a table with information. 16 columns represent months which have
a listing of required quantities. 1 = January and so on for the month,
but the values within the column represent quantities.

I have another table which I would like to bring in. This has a number
of columns as well, one of which contains numbers which correspond to a
month (ie. 1, 3, 15, etc.). Other columns within this table also
contain quantities.

What I would like to do, if its even possible, is bring in quantities
from the second table and display them along with the quantities from
the first table, having the quantities in the second table fall under
the correct month (as displayed in the column heading) according to the
monthvalue in the second table. Essentially merge all quantities into a
single column, using the monthvalue as a reference for which column
they should go into.

Hope that makes some sort of sense
-Sean

 

[John Vinson]

Unfortunately Im pretty new at this, but I'll try and provide as much
info as possilble:

I have a table with information. 16 columns represent months which have
a listing of required quantities. 1 = January and so on for the month,
but the values within the column represent quantities.

Then you have a spreadsheet, not a properly defined Table.

You should NEVER store data - such as months - in fieldnames. A much
better design would be to have two tables in a one to many
relationship; the first table would identify whatever it is that
you're quantitating, and the second table would have a link to the
primary key of the first table, a date/time field identifying the
month, and the quantity. "Records are cheap, fields are expensive!"

I have another table which I would like to bring in. This has a number
of columns as well, one of which contains numbers which correspond to a
month (ie. 1, 3, 15, etc.). Other columns within this table also
contain quantities.

Then this table is equally badly designed.

What I would like to do, if its even possible, is bring in quantities
from the second table and display them along with the quantities from
the first table, having the quantities in the second table fall under
the correct month (as displayed in the column heading) according to the
monthvalue in the second table. Essentially merge all quantities into a
single column, using the monthvalue as a reference for which column
they should go into.

Easy with properly normalized tables; extensive and complicated VBA
code with your current design.

John W. Vinson[MVP]

 

[Joseph Meehan]

Unfortunately Im pretty new at this, but I'll try and provide as much
info as possilble:

I have a table with information. 16 columns represent months which
have a listing of required quantities. 1 = January and so on for the
month, but the values within the column represent quantities.

Let's stop here. This sounds like you have a table design problem. If
so you should fix that before going on.

I guess first question is where are you from that you have 16 months?
This might answer my question.

Normally you would not have 12 let alone 16 columns for months, you
would have a second table with a different record for each month.