Hello everyone,
I am working on a datbase that contains leaks on engines. On one column of the database the leak status can be entered as "active" or "repaired". The next column over will have the leak rate in cfm (cubic feet per minute). I am trying to write a query that will sum the leak rate of active leaks in one column and the leak rate of repaired leake in another.
Something like if "leak status"="repaired" then SUM column
and in the next column on the query if "leak status"="active" then SUM column
I have used if then statements before, just not in access. Any help would be appreciated.
Thanks