S
Shoelaces
I am sure this is not the optimal manner for doing what I want to do, but my
lack of skills has led me to this path. Anyhow . . .
I have a query that has several records. I desire to take this query and
create another that has but one record that contains all of the fields
contained in the first table.
For instance:
Query1
Record1 ID, topic, obj1, obj2, stand1, stand2, stand3, procedure, assess
Record2 ID, topic, obj1, obj2, stand1, stand2, stand3, procedure, assess
etc.
Would become
Query2
ID-1, topic-1, obj1-1, obj2-1, stand1-1, stand2-1, stand3-1, procedure-1,
assess-1, ID-2, topic-2, obj1-2, obj2-2, stand1-2, stand2-2, stand3-2,
procedure-2, assess-2, etc.
Query2 would only have one record with many fields.
Is this possible? If so, how would I go about creating this?
Thanks for the help.
lack of skills has led me to this path. Anyhow . . .
I have a query that has several records. I desire to take this query and
create another that has but one record that contains all of the fields
contained in the first table.
For instance:
Query1
Record1 ID, topic, obj1, obj2, stand1, stand2, stand3, procedure, assess
Record2 ID, topic, obj1, obj2, stand1, stand2, stand3, procedure, assess
etc.
Would become
Query2
ID-1, topic-1, obj1-1, obj2-1, stand1-1, stand2-1, stand3-1, procedure-1,
assess-1, ID-2, topic-2, obj1-2, obj2-2, stand1-2, stand2-2, stand3-2,
procedure-2, assess-2, etc.
Query2 would only have one record with many fields.
Is this possible? If so, how would I go about creating this?
Thanks for the help.