Conditioned MIN Function

[Climbo]

Hello There,

In a table I have a create date and a status, where staus can be "assigned" or "Fixed".

I want to build an expression in a query that will get the Min(

![Create Date]) for all "Assigned" ones.

I need to filter the Status in the expression builder since I have more expressions in that query where the status isn't important, so I can't put a "where" in that query.

Any help would be appreciated,
thanks.

 

[ajetrumpet]

there isn't enough information to give you an answer on this. You have a multiple conditional query need here, and you haven't given us ALL of the conditions that you will be working with to give a concrete answer. Please do so.