How to generate new table from query

C

Charlie

Basically, I have a query that results in two number
fields per record.

Field 1 Field 2
1 2
3 4
I want to create a new table that contains 1.1, 1.2, 3.1,
3.2, 3.3, 3.4.

I'm not a programmer, but I am trying to play one in real
life. :) This appears relatively basic to me, but I can't
seem to get my head around it. Can anyone at least point
me in the right direction?
 
J

John Vinson

Basically, I have a query that results in two number
fields per record.

Field 1 Field 2
1 2
3 4
I want to create a new table that contains 1.1, 1.2, 3.1,
3.2, 3.3, 3.4.
Click to expand...

Ummm... WHY?

This table would be redundant. It would simply contain the same data
as in your current query, reformatted and recombined. A Query can be
used as the recordsource of a form or report, for a mailmerge, for
export, for pretty much anything that you can use a Table for; it's
very rarely necessary to routinely run MakeTable queries.

Also, I don't follow the logic. Where do 3.1 and 3.3 come from (since
Field2 doesn't have values 1 or 3)? Are these numbers text strings, or
decimal fractions?
 
Top