[AccessD] middle X and Y coordinates

Yes, I assumed the X and Y would be numbers.  However, I have changed the table fields to Text(10), re-run the query and it still works OK.  Sending a small MDB (A2K) to you off-line.

Stephen Bond

> -----Original Message-----
> From: Pedro Janssen [mailto:pedro at plex.nl]
> Sent: Thursday, 27 November 2003 8:43 a.m.
> To: Access Developers discussion and problem solving
> Subject: Re: [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
> >
> >
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>