MakeTable Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Problem is that no records are created in the new table.
I have named my query qryFindUpdatedRecords
I do a select query and find 482 records that match my criteria. I then
turn that query into a make table query and when I run it no records are put
into the new table. I am not making the table in my current db.

I have tried this two ways. 1st as mentioned above and 2nd by creating a
complete new make table query, that is based on the query above, and then
running the make table query.

Any direction would be appreciated.

Thanks in advance
 
Problem is that no records are created in the new table.
I have named my query qryFindUpdatedRecords
I do a select query and find 482 records that match my criteria. I then
turn that query into a make table query and when I run it no records are put
into the new table. I am not making the table in my current db.

I have tried this two ways. 1st as mentioned above and 2nd by creating a
complete new make table query, that is based on the query above, and then
running the make table query.

Any direction would be appreciated.

Thanks in advance
Click to expand...

Please post the SQL of the query, and describe how you're running it.
You say "you are not making the table in my current db" - where ARE
you making it, and how are you specifying that location?

John W. Vinson[MVP]
 
Back
Top