table manipulation

T

taccea

Good morning friends,
I am in need of some help with table manipulation.

Table "A" has a [check number] field and a [detail] field.
Each check has 10 rows (records).

Talbe "B" has 11 fields (names irrelevant), one for the checknumber and 10
for 10 details.

I want to create ONE record in table "B" that contains the check number in
field 1 and the 10 detail records in the remaining 10 fields.

How do I go about doing this?
I've read about access SQL but it seems limited...
Any guidance appreciated.

Have a great day !

Taccea
 
J

John Vinson

I want to create ONE record in table "B" that contains the check number in
field 1 and the 10 detail records in the remaining 10 fields.
Click to expand...

It sounds like you need to create a Crosstab query using the check
number as the row header and the other field as the column header.

If you *really really* must, you can base an Append query or a
MakeTable query based on the Crosstab - but I see no good reason to
take a properly normalized table and turn it into a wide-flat
non-normalized one. You can base a Report (or for that matter an
export to Excel) on the crosstab query directly without putting the
data into a redundant table.
 
Top