Make a Table

[ijergas]

hello all,

I have a table like this:

Name NUM Date
Joe 1 12/2
Joe 2 11/1
Steve 4 7/4
Steve 8 8/9
Steve 3 3/2
Alison 1 12/1

And I want to export only the records related to "Joe" to a new table called "NewTable".

Can someone please help me with some code that will do this at the push of a button?

THanks,

josh

 

[ijergas]

Yes, that is exactly what I need to do. But I would like the user to select the person they want to be in the query using a combo box called "select person".

Any chance you could post the code you would use to do the queries that you mentioned?

I so much appreciate your help. Thank you.

Josh

 

[modest]

Do a search for "SELECT INTO" ... this will allow you to create a new table from a select statement. It should be in Access Help and it should be in this forum somewhere (i may have posted on it - i'm not sure)