View Full Version : approximate values query


zhuanyi
05-02-2007, 04:56 AM
hello,
I am just wondering whether there is any way I could define a query in such a way to include a record in Table A if field FA is approximately equal to field FB in Table B by no more than, say 12.

Thanks!

Regards,
Anyi

Dennisk
05-02-2007, 06:18 AM
use a calculation

BETWEEN (tableB.FB -12) AND (tableB.FB+12)