Results 1 to 1 of 1
2002-02-14, 21:58 #1
- Join Date
- Jan 2001
- Houston, Texas, USA
- Thanked 0 Times in 0 Posts
Add totals and Subtract (Access 97)
In a report I have a two fields 1. Status and 2. Est. Count.. I do =sum([ak]) to get the total number for Est. Count.
How can I have it check the status, and if it equals completed I want to total up and display the completed records total and then subtract them from the sum([ak]) to give me what the difference is.