Need access help

Re: Need access help

Open the table in design view and select the number field which you would like to make changes to. Then, at the bottom you'll find a group box which says 'Field Properties'. In there, change the format to 'General Number'. This should give you the desired result.

Here's a screeny to help:
[thumb=H]numberFormat14221_5120901.JPG[/thumb]