How to generate new table from query

  • Thread starter Thread starter Charlie
  • Start date Start date
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?
 
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?
 
Back
Top