microsoft+access+training - Problems with numbers

The UK's most regular instructor-led training courses.
Training information: microsoft+access+training · Courses in microsoft access · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Problems with numbers

Jason has attended:
Access Intermediate course

by - delegate Jason [1 post] (2007 Feb 6 Tue, 09:55) Reply

I've imported a DBF file into Access, but my numbers originally to 1dp, have been replaced by numbers such as 2.200000000978. Why is it doing this?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 14 Wed	Bloomsbury	7	book now	£203	£230
2003	2009 Jan 23 Fri	Bloomsbury	7	book now	£203	£230
2003	2009 Jan 28 Wed	Bayswater	8	book now	£195	£205
2007	2009 Jan 28 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Feb 4 Wed	Southwark	8	book now	£187	£224
2003	2009 Feb 11 Wed	Bloomsbury	7	book now	£203	£230
Full Schedule: See all 51 Access Advanced course dates. Bookings currently available until 24th March 2010.

RE: Problems with numbers

by - trainer Richard platinum contributer [825 posts] (2007 Feb 6 Tue, 11:21) Reply

It could be an issue with the field properties. Have a look at the field type, format, and decimal places settings. (make a backup of the table before modifying it, so you can go back to the original if need be.

IF you do not have any luck, you could import the DBF file to Excel, format as you require, and then reimport to Access. bear in mind that DBF is not a Microsoft product, so the integration may not be as smooth as it would be with products from the Microsoft family.

· How To Find Good Access Database Courses In London
· Reasons to Consider Microsoft Access Training
· The Benefits of Certified Microsoft Training in Access
· Microsoft Access Training Opens Doors
· Why a Microsoft Access Course Could Change the Way You Do Business

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips

Rate this page: