Recent content by streamsleek

I am not the greatest at explaining things, and I think i may have confused everyone. the user will select the department "warehouse-bulk" from the list on the form (about 6 departments total). Then the query will include records from departments "warehouse-bulk", and "warehouse-retail"...

I changed it to IIf([Forms]![dateselect]![dept]="Warehouse-Bulk",([Errors].[Department])="Warehouse-Bulk" Or ([Errors].[Department])="Warehouse-Retail",[forms]![dateselect]![dept]) And now i am getting a message stating " This expression is typed incorrectly, or it is too complex to be...

I have a situation where a user would like to pull two department types in a query. I previously had the criteria defined by a form field. So if "warehouse-bulk" is selected on the form, it will pull the records for "warehouse-bulk, and 'warehouse-retail". I have attempted this with the below...