adding data from table 1 to table 2

[GEONPS]

I have two tables they both share column 'Mile Markers'. Table 1 lists all mile marker from 0-60 in 0.1 mile increments, in order. It also has a column for x and y coordinates. Table two only lists 435 random mile markers. Is there a way to add the correct coordinates to the 435 mile markers in table 2 from table 1?

Thanks for any help,

Screen shot of table 1



Screen shot of table 2

[John_G]

In theory yes, but in actual practice (i.e. in MS Access) I'm not sure. Because your mile marker values are decimal numbers, many of them cannot be represented internally in the computer with 100% accuracy. (limitation of binary representation).

But you have not shown screenshots of MS Access tables - those are Excel. Please post the same data but using MS Access tables. Note Table2 needs X and Y fields as well.

John

[GEONPS]

Mile MarkerTables



Mile marker without coordinates

[John_G]

Hi -

You can make an update query, joining the two tables on [Mile Marker], and including all the fields for [Odomenter Readings]. Update [Odometer readings].[x] to [mm db].[x] and [Odometer readings].[y] to [mm db].[y]

This probably will work - but note the caveat I mentioned in my previous post, about decimal numbers and computers.

John

[GEONPS]

Thanks for your help John


Good start?

[GEONPS]

It worked!!!! Thank you very much John! You Rock!!!!!!!!!!!!!