[AccessD] middle X and Y coordinates

Pedro

You don't say how the results relate to the data - or am I missing something
obvious?

John


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Pedro Janssen
> Sent: 24 November 2003 21:22
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] middle X and Y coordinates
> 
> 
> Hello Group,
>  
>  
> I have a table with two fields which are X and Y coordinates. 
>  
> X                     Y
>   97,234           234,632
>   98,456           257,678
> 107,453           278,945
> 107,234           278,346
> 109,123           245,567
>  
> i need as result
>  
> X                     Y
>   97,500           237,500
>   97,500           257,500
> 107,500           277,500
> 107,500           277,500
>  
> on the result i would like a distinct.
>  
> 
> 
> Can this be done in one query?
>  
> TIA
>  
> Pedro Janssen
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
>