[AccessD] middle X and Y coordinates

Hello Stephen,

i get 0 as result. Something is going wrong.
The fields normally are text fields.
I changed them into Number fields, Double, 3 decimal places.
I added two fields. MidX and MidY.
Made an update query and updated MidX and -Y. with Int([x or
y]/2500+0.5)*2500

What is going wrong?

Pedro Janssen




----- Original Message -----
From: "Stephen Bond" <stephen at bondsoftware.co.nz>
To: <accessd at databaseadvisors.com>
Sent: Tuesday, November 25, 2003 8:21 PM
Subject: [AccessD] middle X and Y coordinates


> Pedro,
>
> If you want the numbers to the nearest 2500, in the query put 2 derived
fields
>
>    MidX: Int([x]/2500+0.5)*2500
>    MidY: Int([y]/2500+0.5)*2500
>
> Does this answer your question?
>
> Stephen Bond
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>