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

[Guest]

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/!

 

[Guest]

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.

 

[Guest]

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!

 

[Guest]

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