davidckchiu
New Member
- Joined
- Feb 24, 2018
- Messages
- 2
Dear friends,
I am new to Access.
I am working to select records based on criteria using a calculated field. The criteria is the ratio of 2 fields is smaller than certain number.
When I tried it using the imported SQL DB, it works.
But when I use linked SQL DB, same DB and same calculated field and same criteria, the queries return records not based on criteria in the calculated field.
Can't figure out why ? Any hintes ?
Thanks in advance.
DC
I am new to Access.
I am working to select records based on criteria using a calculated field. The criteria is the ratio of 2 fields is smaller than certain number.
When I tried it using the imported SQL DB, it works.
But when I use linked SQL DB, same DB and same calculated field and same criteria, the queries return records not based on criteria in the calculated field.
Can't figure out why ? Any hintes ?
Thanks in advance.
DC