Creating a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to create a unique type of table.

I have a select query that returns a list of values. Specificly, the query
returns a column named "Paramaters" with two values "First Name" and "Last
Name". I then want to create another table where the columns in that table
would be the results, so in my example, the new table would have "First Name"
and "Last Name" as data to be filled in.
 
I'm trying to create a unique type of table.

I have a select query that returns a list of values. Specificly, the query
returns a column named "Paramaters" with two values "First Name" and "Last
Name". I then want to create another table where the columns in that table
would be the results, so in my example, the new table would have "First Name"
and "Last Name" as data to be filled in.
Click to expand...

The first thing to ask is... do you need another TABLE? I'd say no,
you don't. A Select Query can return a list of values; that Query can
be used as the basis of a Form, a Report, it can be exported, it can
be sorted, it can be used as the basis of another Query... pretty much
anything. Creating a new table just stores data redundantly and wastes
space and time.

Secondly... your Parameters field should not contain two values.
Fields should be "atomic" and have only one value. If you mean that
your Parameters field contains the literal text

"First Name" "Last Name"

then I really don't understand what you're trying to accomplish!

John W. Vinson[MVP]
 
Back
Top