More Access, Less VB

Hi, okay, I'm sorry, but this is more of an Access question than a strictly VB one, but I'm using the Access for my VB App, so I guess it kind of counts.... ;-)

I'm using a query to perform some calculations for me in Access, it tends to return a "Double" data type and I really wan to use an integer. Can anyone make any suggestions on how to convert these?

Or should I give up on using a query and doing everything via VBA instead?

FDR

I belive you will need to set the form or report text box (which ever you are using your query for) to the format you wish.