query with columns calculations (1 Viewer)

Hi,

I've a query with columns TRef (Primary Key), SQuota, SPSQuota, SessionCnt. I need to build a query to apply the below criteria and then sort them in order of effectiveQuota.

if (SPSQuota x SessionCnt) >= SQuota then
effectiveQuota = SQuota
else
effectiveQuota = (SPSQuota x SessionCnt)

Pls. find the attached test data for the above work.

Welcome any advice on this.

create New query from your first query adding the new column:

Select TRef, SQuota, SPSQuota, SessionCnt, IIF((SPSQuota * SessionCnt) >= SQuota , SQuota, (SPSQuota * SessionCnt)) As effectiveQuota From qryTAvail_PIP1_SessionCnt Order By IIF((SPSQuota * SessionCnt) >= SQuota , SQuota, (SPSQuota * SessionCnt))

Thank you. It worked perfectly.