Please note: Action Log (table name), Action Type(dropdown options w/ in Action Log), Complete (Criteria),and Action Date (Date time field w/in Action Log).
As a Field Name I place this in my Query:
And Expression in the Total type
Now I need to make this Expr1 only work for the Action type Delayed.
Example: Total 17
Delayed = 5
Dropped = 1
New = 7
Complete = 4
What I get w/ the Expr1 is 13 for all. What I need is
Example: Total 17
Delayed = 1 (this should be 5(Delayed)-4 (Complete))
Dropped = 1
New = 7
Complete = 4
This will end up in a report. I posted that question as well. So if you need info on the end game you may wish to read that one too. Thank you!
As a Field Name I place this in my Query:
Code:
Expr1: DCount("*","Action Log","[Action Type] <> 'Complete' AND [Action Date] IS NOT NULL")
Now I need to make this Expr1 only work for the Action type Delayed.
Example: Total 17
Delayed = 5
Dropped = 1
New = 7
Complete = 4
What I get w/ the Expr1 is 13 for all. What I need is
Example: Total 17
Delayed = 1 (this should be 5(Delayed)-4 (Complete))
Dropped = 1
New = 7
Complete = 4
This will end up in a report. I posted that question as well. So if you need info on the end game you may wish to read that one too. Thank you!
Comment