Surjer
Registered User.
- Local time
- Today, 15:44
- Joined
- Sep 17, 2001
- Messages
- 232
I have 2 tables
Final_MH
and
Dup Checks
Then I have 1 querySELECT Final_MH.*, [DUP CHECKS].*, [Final_MH]![Northing]-[DUP CHECKS]![NORTHING] AS Expr1, [Final_MH]![Easting]-[DUP CHECKS]![EASTING] AS Expr2, [Final_MH]![Elev]-[DUP CHECKS]![ELEV] AS Expr3, [DUP CHECKS].MH_ID
FROM Final_MH, [DUP CHECKS]
WHERE ((([DUP CHECKS].MH_ID)=[Final_MH]![MH_ID]));
Then I have a report that lines up the appropriate fields and shows the difference between the two records!
Is there a way to Color the results "RED" if they are over "0.02"?
Thanks in advance,
Jerry
Final_MH
and
Dup Checks
Then I have 1 querySELECT Final_MH.*, [DUP CHECKS].*, [Final_MH]![Northing]-[DUP CHECKS]![NORTHING] AS Expr1, [Final_MH]![Easting]-[DUP CHECKS]![EASTING] AS Expr2, [Final_MH]![Elev]-[DUP CHECKS]![ELEV] AS Expr3, [DUP CHECKS].MH_ID
FROM Final_MH, [DUP CHECKS]
WHERE ((([DUP CHECKS].MH_ID)=[Final_MH]![MH_ID]));
Then I have a report that lines up the appropriate fields and shows the difference between the two records!
Is there a way to Color the results "RED" if they are over "0.02"?
Thanks in advance,
Jerry