How to change the datatype in a query?

[Aisha00]

Hello everyone, I was doing an assignment in which i created a query and performed a calculation in it; the answer of the calculation should be as an integer whereas the answer i got is suppose "6.7779999", if i'm not wrong the only way to change my answer to an integer is by changing the data type, and i spend about half an hour trying to find a way to do so but in vain, so i was wondering if anyone here could please help me out. Thankyou


P.s- I've been using office for quite some time now but the sql thing is pretty new to me, so if anybody suggests making any changes to it, can you tell me how exactly to do it aswell please? and bt the SQL view for my query is provided at the end and i wanna change the data type of hours worked to integer ..... SELECT DISTINCT Technician.[Technician Number], Technician.[Last Name], Technician.[First Name], Technician.[Hourly Rate], Technician.[YTD Earnings]/[Hourly Rate] AS [Hours Worked]
FROM Technician
GROUP BY Technician.[Technician Number], Technician.[Last Name], Technician.[First Name], Technician.[Hourly Rate], Technician.[YTD Earnings]/[Hourly Rate]
ORDER BY Technician.[Last Name];

 

[not so gray matter]

Not sure if this is what you're looking for:

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

RESPONSE

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

 

[Aisha00]

Not sure if this is what you're looking for:

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

RESPONSE

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

Isn't that only for the alias?, i might be wrong...i'm sry, its just tht i'm kinda new to all this!

 

[Bill2]

In Access, you can use the ROUND function with the appropriate parameter to get your desired result. Read this.

Access: Round Function