approximate values query

[zhuanyi]

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]

use a calculation

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