create two new tables from one existing table

[timhans]

Hello
very new to writing sql,I need to create two new tables from one existing table.

One table is all of the data of 1Section and the second table is all of the data of 2Section.

I have been trying but not getting it.

Any help is very appreciated.

Thanks

| ID | SUBJECT | RELATIONSHIP | 1SECTION | COL5 | COL6 |
---------------------------------------------------------------
| 1 | John | Boss | 1Section | 1sQuestion1 | 2 |
| 2 | John | Peer | 1Section | 1sQuestion1 | 4 |
| 3 | Sally | Boss | 1Section | 1sQuestion1 | 3 |
| 4 | Sally | Peer | 1Section | 1sQuestion1 | 5 |
| 1 | John | Boss | 1Section | 1sQuestion2 | 4 |
| 2 | John | Peer | 1Section | 1sQuestion2 | 3 |
| 3 | Sally | Boss | 1Section | 1sQuestion2 | 3 |
| 4 | Sally | Peer | 1Section | 1sQuestion2 | 6 |
| 1 | John | Boss | 2Section | 2sQuestion1 | 3 |
| 2 | John | Peer | 2Section | 2sQuestion1 | 2 |
| 3 | Sally | Boss | 2Section | 2sQuestion1 | 4 |
| 4 | Sally | Peer | 2Section | 2sQuestion1 | 1 |
| 1 | John | Boss | 2Section | 2sQuestion2 | 4 |
| 2 | John | Peer | 2Section | 2sQuestion2 | 5 |
| 3 | Sally | Boss | 2Section | 2sQuestion2 | 5 |
| 4 | Sally | Peer | 2Section | 2sQuestion2 | 3 |

 

[dhookom]

Why would you need to create new tables when we typically use queries to create a filtered record set. If you really want to create two tables, you could build to make table queries.

Duane
Hook'D on Access
MS Access MVP

 

[SkipVought]

Hi,

Chopping data up into multiple locations (tables) only serves to complicate life. What is the business case for this exersize?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]