Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by djdehaan
-
Finding a row with a binary status
Hi All, Thanks for your thinking. I prefer not to include Access code (it is a .net web app). I now have a flex way to do it, as follows: WHERE (((Fix(([Caps]-(Fix([Caps]/B))*B)/A)=1))) A is the num value of the bit i look for and B is the num value of the next bit- djdehaan
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Finding a row with a binary status
No, does not work with me (Access 2003). Zero records returning. It looks like Access evaluates 'Caps' as a boolean and also 4 (although all are Numbers).- djdehaan
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Finding a row with a binary status
Hi, I use in an SQL table an Integer column called 'Caps' to store capabilities. Each bit of the integer represent a capability. Now I need to select in an SQL statement only those rows that have a specific capability. And i cant find how to do this! Someone knows? Assume -row 1 of the...- djdehaan
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
