Hi,

Does anyone know how to convert a text field to an Integer field when
running a amake table query??????

Thanks Guys!

Tim
This e-mail transmission is strictly confidential and intended solely 
for the person or organisation to who it is addressed.  It may contain 
privileged and confidential information and if you are not the 
intended recipient, you must not copy, distribute or take any action 
in reliance on it.  
If you have received this email in error, please notify us as soon as 
possible and delete it.
This e-mail has been scanned using Anti-Virus software, however, 
Swansea NHS Trust accept no responsibility for infection caused by 
any virus received on the recipients system.

use a conversion function in the query

select cstr(NumField) as NewFieldname...

-----Original Message-----
From: Tim Maher [mailto:tim.maher@s...]
Sent: Tuesday, August 27, 2002 9:57 AM
To: Access
Subject: [access] Convert Text field to Integer in a make table query


Hi,

Does anyone know how to convert a text field to an Integer field when
running a amake table query??????

Thanks Guys!

Tim
This e-mail transmission is strictly confidential and intended solely 
for the person or organisation to who it is addressed.  It may contain 
privileged and confidential information and if you are not the 
intended recipient, you must not copy, distribute or take any action 
in reliance on it.  
If you have received this email in error, please notify us as soon as 
possible and delete it.
This e-mail has been scanned using Anti-Virus software, however, 
Swansea NHS Trust accept no responsibility for infection caused by 
any virus received on the recipients system.