I IanT Registered User. Local time Today, 18:29 Joined Nov 30, 2001 Messages 191 Aug 15, 2011 #1 In a query I get results like: 916576.15 3230200.86 I only want to show thw values as £000s, for example: 916 3230 Can anyone advise!
In a query I get results like: 916576.15 3230200.86 I only want to show thw values as £000s, for example: 916 3230 Can anyone advise!
bob fitz AWF VIP Local time Today, 18:29 Joined May 23, 2011 Messages 4,806 Aug 15, 2011 #2 You could use the CInt() function if you want the number rounded. Else use Int() function.
Brianwarnock Retired Local time Today, 18:29 Joined Jun 2, 2003 Messages 12,667 Aug 15, 2011 #3 bob fitz said: You could use the CInt() function if you want the number rounded. Else use Int() function. Click to expand... But first divide by 1000 Brian
bob fitz said: You could use the CInt() function if you want the number rounded. Else use Int() function. Click to expand... But first divide by 1000 Brian
bob fitz AWF VIP Local time Today, 18:29 Joined May 23, 2011 Messages 4,806 Aug 15, 2011 #4 Thank you Brian. Good catch. I didn't read the post carefully enough.
