Search results for query: *

The location is the Nursestation and the class is the AHFS classification. I do not have the date range built - I am just using transaction date right now.

Here is the SQL for my query SELECT TOP 100 PDM.LABEL_NAME AS [Generic Name], PDM.BRAND_NAME AS [Brand Name], Nz([THERA_CODE_FMT],"92:00.00") AS [AHFS Classification], Nz([THERA_DESC],"MISCELLANEOUS THERAPEUTIC AGENTS\1") AS [Therapeutic Category], PDM.ROUTE, PHM_CURES.TRANS_DATE...

They put a date range in and click a "RUN REPORT" button. A report would then appear with the drug class information for the locations they picked from the drop down.

Thank you for responding. I want users to be able to select one or all drug classes and, I want them to pick one or all locations. There are hundreds of drug classes, so I put a drop down in the form to limit to the ones that are relevant for the report's use.

To prevent this from happening again - Goto Tools, Macro ,Security and set the security level to Low

I am building a form to look for classes of drugs in a query. I have 2 drop downs. I have manually added the classes to one dropdown. I have manually added locations to the other. I have added a option of ALL in both dropdowns. I think the easiest way would be to write a command in the query...