[AccessD] middle X and Y coordinates

Hello John,

sorry that i didn't give a relation between the data and the result. I
thought that this was clear.

The result has to be the middle (2,500) from 0 to 5 when the first number
after the comma lies between this value.
The result has to be the middle (7,500) from 5 to 10 when the first number
after the comma lies between this value.

I'll hope this explains a little bit more together with the data and the
result.


Pedro



----- Original Message -----
From: "DJK(John) Robinson" <djkr at msn.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Tuesday, November 25, 2003 12:55 AM
Subject: RE: [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
> >
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>