Hi

I need a query that searches 2 fields in 2 tables. Below is an example.

There are 2 numeric fields in each of the 2 tables containing numbers such
as 51.565842 in 1 field and -0.331336 in another . I need the query to
search the other table and to compare the first 3 digits ie 51.5 and -0.33
and return a result, if that result returns more than 1 record then the
query searches the next digit ie 51.56 and -0.331 and so on until only 1
record is returned.

I know this may sound complicated, but i really need help on this one.

Thanks in advance.

Simon Gare

You can easily do this with 3 queries:

Query1:
SELECT Max(Table1.First) AS MaxOfFirst
FROM Table1;

Query2:
SELECT Max(Table2.Second) AS MaxOfSecond
FROM Table2;

Query3:
SELECT Query1.MaxOfFirst, Query2.MaxOfSecond,
IIf([MaxOfFirst]>[MaxOfSecond],[MaxOfFirst],[MaxOfSecond]) AS Largest
FROM Query1, Query2;
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access


"Simon Gare" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> Hi
>
> I need a query that searches 2 fields in 2 tables. Below is an example.
>
> There are 2 numeric fields in each of the 2 tables containing numbers such
> as 51.565842 in 1 field and -0.331336 in another . I need the query to
> search the other table and to compare the first 3 digits ie 51.5 and -0.33
> and return a result, if that result returns more than 1 record then the
> query searches the next digit ie 51.56 and -0.331 and so on until only 1
> record is returned.
>
> I know this may sound complicated, but i really need help on this one.
>
> Thanks in advance.
>
> Simon Gare
>
>
>