Hi,

I am using the following expression in the criteria portion of the query in the query design mode:

Like [forms]![Administrative Reports]![Company]

[Company] is the name of the first combo box and [Platoon] is the name of the second combo box on the administrative reports form footer.  When I have this LIKE expression in the criteria portion of the query in query design mode without adding the [Platoon] LIKE expression the query works fine.  When I add the [Platoon] LIKE expression in the criteria portion of the query in the query design mode it doesn't pull the data I ask in the example I gave in my initial question of pulling data from Company "B" and Platoon "C" and display this data in a report.  So what would be the expression in the criteria portion to use in order for this query to work correctly for pulling data from Company "B" and Platoon "C" and display this data in a report in this case?  Can you use a select statement in the criteria portion of a query in the query design mode of a query and have the query work right as it's supposed and intended to?  Essentially what I'm asking actually would add two queries from two different combo boxes into one query and form a report from this query.  Also if the values in either combo box is blank or is null then I want to display all data in that specified Company or those specific Platoon(s). Thanks for your continued support and all that you do!

very respectfully,

EZELL MARTIN