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