Make Table Query Question

R

RNUSZ@OKDPS

I have two related tables, CASE_RECORDS and CASE_OTHERS.

CASE_RECORDS has the following fields:
Field Name - Field Type
Case_Num_Yr - Numeric - Limited to 4 digits - Primary Key Part 1
Case_Num - Numeric - Small Integer - Primary Key Part 2
Lic_First_Nme - Text - 30 characters
Lic_Middle_Nme - Text - 1 characters
Lic_Last_Nme - Text - 30 characters
Lic_Subt_Txt - Text - 5 characters
Lic_Addr_Txt - Text - 30 characters
Lic_City_Nme - Text - 30 characters
Lic_State_Cde - Text - 2 characters
Lic_Zip_Cde - Text - 5 characters
Lic_Zip4_Cde - Text - 4 characters

I want to be able to run a query hopefully to create another temporary
table with the following format:

Field Name - Field Type
Case_Num_Yr - Numeric - Limited to 4 digits - Primary Key Part 1
Case_Num - Numeric - Small Integer - Primary Key Part 2
Licensee_Nme - Text - 70 characters (joined Lic_First_Nme, space,
Lic_Middle_Nme, Lic_Last_Nme, Lic_Subt_Txt in format of Robert E Roberts
Jr)
Lic_Addr_Txt - Text - 30 characters
Lic_City_Nme - Text - 30 characters
Lic_State_Cde - Text - 2 characters
Lic_Zip_Cde - Text - 5 characters
Lic_Zip4_Cde - Text - 4 characters

Can this be done via Query with INTO statement or does it have to be done
via VB code / procedure / function. What would be the best way to do this?
Any suggestions would be greatly appreciated.

Thanks in advance...
 
O

Ofer

Create a Temp table as you want and instead of running a make table query run
two queries instead:
1. delete data from table
2. Append query
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top