Imported Table, Queried, now too many decimal places!!! Help

B

Bryan

I imported a table from a GIS program. I ran a query on the table, and my
query table now has 10 decimal places for the numbers, and I cannot figure
out how to edit them. I can't even delete them manually.

Any ideas? I only want 2 decimal points. Thanks/!
 
B

bob norris

Bryan:
you can format the display of data, in the query grid, right click on the
column of the data to be formated and pick properties. In the properties
dialogue box, click format and select standard if you want commas, e.g.
10,000,000 and then in the decimal places, type 2. if you're not worried
about the commas, you can leave format blank and simply set the decimal
places.
 
B

Bryan

Bob-

It says that the data cannot be modified in a linked table. Is it considered
linked if I import it in from another source and not create the table in
Access?

Is there any way around that?

Thanks!
 
B

bob norris

when you bring a table into Access you have one of two choices (at least in
Access 2000 - 2003), either import the table or link the table. In access
2000, the steps are
1. <alt><f> to go to the file menu
2. <g> to get data
3. <i> to import
or
3. <L> to link a table
4. navigate to the desired data source

if you "linked" the table, you can delete it from the access database window
and bring the data in again, this time try to "get" the table rather than
"link" the table.

bob
 
M

mutlu

in the design view of the table change the type of the field name and make it
"number" then in the general part there is a place to adjust the number of
decimal places. Make it zero or decrease it until an acceptable number
Tables/yourDatabease./design view(make the field number)/general-decimal
places
 
Top