Comments by bwhittington (Top 5 by date)

Thanks for your time on this! It really cleared the fog. I am not ready yet to go and start doing these calculations yet but I think I can hack my way through one if I see it. Much appreciated!

The query was already written and it works but I am having trouble understanding how it works because I have found I don't understand bitwise operators. I'll update my post to include that information. Thank you for your reply.

I am going to do some more studying on this tonight and tomorrow because I can't wrap my feeble brain around it. How did you know to use bit 3 and bit 4? Is it because 8 is the 3rd bit and 16 is the 4th bit on the binary scale? I feel like I am missing one piece of information before this puzzle makes sense.

I am sure you are giving me the correct answer because I did a select on the database to count all of the values that are "Flags & (8 | 16) = 16)" and none of the values I gave were in that list.

Thank you for your response. I've worked with a couple of test questions using "Option 2" and I like the results. Unfortunately, I can't post my examples for others because its work related but hopefully your options help others as well.