I am new to using Access 2007 and I am creating a database for work. On one form I have text boxes for GPS coordinates. One set is a known point in x and y and the other set is a measured x and y (UTM coordinates). I want to display the offset of these two different measurements. Simple equation. I just don't know what is the best way to do this in Access. Should it be done on the form in a text box (and then stored in the table) or should a query be used. How is this set up?

Equation is d=[(x2-x1)^2+(y2-y1)^2]^1/2 or

d=sqrt[(x2-x1)^2+(y2-y1)^2]

x1=txtControlNorthing

y1=txtControlEasting

x2=txtMeasuredNorthing

y2=txtMeasuredEasting

Thanks

Do the coordinates already exist in a table, or are you looking to have the user populate a table by typing the coordinates into a form and calculating the offset after all four numbers have been entered?

Best,

Pat