Kelly@AllenEnt
Registered User.
- Local time
- Today, 10:40
- Joined
- Oct 4, 2012
- Messages
- 51
Hello,
I have a database that has a check box that automatically checks when the outstanding amount is less than or equal to $0.05.
=IIf([OUTSTANDING]<=0.05 And [COMMISSION]>=0,-1,0)
When the criteria is true, my Form automatically checks the box marked "paid".
I have a report based on a query so I know which documents I need to pull based on a certain date. What I need it to do is filter out those that have a check in the paid column. PAID is not listed on the orders table but OUTSTANDING is. I tried adding the OUTSTANDING column to my query and putting the criteria to <=0.05 but nothing shows in the column when I run the query. I believe that is because it is also a calculated amount.
=Nz([COMMISSION],0)-Nz([txtTotalPayments],0)
Does anyone know how I can make the query work?
I have a database that has a check box that automatically checks when the outstanding amount is less than or equal to $0.05.
=IIf([OUTSTANDING]<=0.05 And [COMMISSION]>=0,-1,0)
When the criteria is true, my Form automatically checks the box marked "paid".
I have a report based on a query so I know which documents I need to pull based on a certain date. What I need it to do is filter out those that have a check in the paid column. PAID is not listed on the orders table but OUTSTANDING is. I tried adding the OUTSTANDING column to my query and putting the criteria to <=0.05 but nothing shows in the column when I run the query. I believe that is because it is also a calculated amount.
=Nz([COMMISSION],0)-Nz([txtTotalPayments],0)
Does anyone know how I can make the query work?