access+training+in+london - Access and reports

Resolved · Low Priority · Version Standard

Access and reports

Sue has attended:
No courses

by - delegate Sue [1 post] (2007 May 22 Tue, 10:54) Reply

In an existing report how do i round the numbers up to the nearest thousand, and show them without zero's eg, 32000 i would want to show as 32

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	3	book now	£475	£495
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: access and reports

by - trainer Pete platinum contributer [801 posts] (2007 Jun 8 Fri, 11:53) Reply

Hello Sue,
Thanks for your post, to solve your problem, open your report in design view, select the control to which you wish to apply the rounding, open the properties page for the control, in the Format row enter the following code: #,##0,;[Red](#,##0,);-

This will only return the Thousands values, and will give negative numbers in red surrounded by brackets ()

hope that now works

Pete