Appending records from another table

[kev88]

Hi everyone,

I'm learning the basics of Access and I was looking for advice with regards to appending.

I have a large transaction table that I am trying to break down. It had over 20 fields in it and it contains transactions with details such as customers and the products they bought.

I am trying to copy the details of the products, such as product code, to a smaller table but I'm having trouble doing it as I only want a few fields copied rather than the whole table. How do I go about doing this?

Thanks for your help

 

[Alansidman]

Create a query and include only the fields you want. Change the query to a make table query. Run it and you will have in a new table only the data you want.

 

[kev88]

Thanks for your help.

Could you break that down for me? I'm a beginner so I'd really appreciate your help

 

[kev88]

I should add that I want to move existing transactions to the new tblProduct that I've created.

 

[Alansidman]

How to create a select query

http://support.microsoft.com/kb/304361

How to create a make table query

http://office.microsoft.com/en-us/access-help/create-a-make-table-query-HA010108505.aspx

Will need more information on the transactions table and specifically what you want to do once you get your new table established.