Board index Office Access

Change Data Type in Query

Change Data Type in Query

Post by WklNTUp » Wed, 16 May 2007 04:13:01


I have a field CMS_STDY_PRD

In my query I want to
1) change the data type to character
and
2) give the field an Alias of Study_Period.

How do I change the data type in a qry?
Is it possible to change the data type and the field name in the same step?

JZ
 
 
 
Top

Change Data Type in Query

Post by John Spenc » Wed, 16 May 2007 04:37:15

If you mean you only want the change to happen in the query results and not
have any effect on the actual data stored the table.

Field: Study_Period: CMS_STDY_PRD & ""

In an SQL statement that is

SELECT CMS_STDY_PRD & "" as Study_Period, ...

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.

 
 
 
Top

1. Append Data Type Text Y/N to Data Type Y/N in Query HELP!

2. How can I change a field name's data type automatically in query?

3. Why does UPDATE query change data type?

4. SQL query changes field data type

5. Can I use a query to change a data type?

6. Query which includes a column whose data type is memo type is crashing

7. Data Type mismatch in a query that uses a calculated field from another query

8. data type mis-match in query based on query

9. Data Transfer from Long data type to SQL Server Text data type column

10. Which is better way to changed data length/data type in sql server 2000 ?

11. how to change the type of office data file to personal data file

12. Data Type and Data Size Changes

13. Unable to change data type in field options when importing data f.

14. How to change a number or text data type to autonumber and keep the table data?

15. Can form field box be automatically changed when table field data type changes?

All times are UTC
Board index