SELECT TblCustInfo.CID, TblCustInfo.Name, TblCustInfo.Addr, TblCustInfo.Zip, TblCustInfo.Cancel, TblCustInfo.SrvAmt
FROM TblCustInfo
GROUP BY TblCustInfo.CID, TblCustInfo.Name, TblCustInfo.Addr, TblCustInfo.Zip, TblCustInfo.Cancel, TblCustInfo.SrvAmt
HAVING (((TblCustInfo.Cancel)="n") AND ((TblCustInfo.SrvAmt)>[?]));
This query lists all customers and their service amounts that are greater than a prompted parameter input. As in, I input 22, it lists all customers with service charge amounts greater than 22.
I would like to add a column in a report that shows the difference in the SrvAmt and the input amount (parameter).
How does one capture the input amount to use in an expression to subtract it from the SrvAmt ?
Ex. I input 20, the SrvAmt is 34, the new 'diff' column would show 14.
I have tried every way I can think of to no avail.
As usual, probably something simple.