Forum home » Delegate support and help forum » Microsoft Access Training and help » access+training+in+london - Access and reports

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

access+training+in+london - Access and reports

Resolved · Low Priority · Version Standard

Reply Tue 22 May 2007, 10:54Delegate Sue said...

Sue has attended:
No courses

Access and reports

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

For upcoming training course dates see: Pricing & availability

Reply Fri 8 Jun 2007, 11:53Trainer Pete said...

RE: access and reports

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

Access articles

· Insert A Real-Time Clock In An Access Form
· Learn The Secrets About Splitting An Access Database
· Getting to grips with Access 2007's Opening Screen and User Interface
· What You Need To Know About New Security Features In Access 2007
· How To Use Multiple Parameters In A Microsoft Access Query

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy