Auto adding field

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

How do you automatically add a field(s) or column. With
the name of a value from another table?

Table "Vehicle Types" have values of Sedan, Mini bus,
Limosuine.

I would like to make these values column headings in a
seperate table.
 
How do you automatically add a field(s) or column. With
the name of a value from another table?

Table "Vehicle Types" have values of Sedan, Mini bus,
Limosuine.

I would like to make these values column headings in a
seperate table.
Click to expand...

I don't think that a separate table would be at all a good idea:
storing data redundantly is unwise, and storing data ("Sedan" for
instance) in a fieldname is even worse.

What you can do is create a Crosstab Query using VehicleType as the
column header. If you REALLY want to create a non-normalized, hard to
maintain, redundant table, you can base a MakeTable query on the
Crosstab query - but I wouldn't if I were you; you can just base a
Form or Report directl on the query.
 
Back
Top