I'm trying to write a query expression to run on the database so I can filter out these items when running reports. Thing is, I can't find any SQL functions for easily dealing with the bit-coded values like those in the FLAG field. Any suggestions?

If you are using VBA the operands are already bitwise. See the "Ambiguous Operators" section. For true SQL, see this article "SQL bitwise" . Hope that helps.

Somewhat. Eventually it will be using VBA and I will be able to work that out then, but right now its just using filters and queries. There are no bitwise operations that I can see - & is used to concatenate strings and AND is used for logic control rather than an operator.

After an afternoon of playing with the syntax (joy...), it looks like it will be a round-about solution. ([FLAG] Mod 8) gives a result of >= 4 if bit 4 is set, < 4 if bit 4 is cleared. For example, with FLAG as 519 (512 + 4 + 2 + 1) it gives a result of 7 while with FLAG as 515 (512 + 2 + 1) it gives a result of 3.

Hopefully the attached db will save you some joy. I created a created vba function that you can use in a query. There is a sample query demonstrating it's use. Also attached is a pdf defining the flag/status fields.

I can't seem to get the ZIP to download, but thanks anyways.

I am trying to run the plant database here for one specific client. I am loving the ability to change descriptions, sort by line number etc. My problem is that I don't have enough experience with database to query out the existing components when trying to run my global BOM. I found the flag valve sheet from wolfe above but don't really understand how to use that without vba or sql.

I finally got the time to figure out a simple query for existing components in the plant pro database.

SQL
SELECT PIPE.DWG_NAME, PIPE.ALPHA_SIZE, PIPE.LINE_NUM, PIPE.LONG_DESC
FROM PIPE
WHERE (((([PIPE]![FLAG]\(4)) Mod 2)=0));

Thanks for pointing me in the right direction Wolfe.

Steve

Nicely done. Glad to be of help.

Thanks a lot Shollinger & Dave Wolfe

You solved my problem