Change Data Type in Query

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

Guest

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
 
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
..
 

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

Similar Threads

union qry problem 4
Split data in field on character return 0
Access IIF and Instr function 1
Excel Help to copy information from one row at a time to another sheet 1
Changing data type in a Query 3
Force data type from Text to Memo in a simple Make Table Query 1
change data type in query through a link table 1
Yes / No query problem 4

Back
Top