I created a report based on a query that counted each occurrence of Problem by Year, Month. The report gives me the correct total for month and correct total for YTD however, I can not figure out the expression for YTD Total for the detail section. Any suggestions would be greatly appreciated...
Create a macro where Action = "Open Form" and in the "Action Arguments" section View = "Datasheet". Fill in the necessary info in the other Action Arguments.
Attach the macro to the on open function.
Susanne
is there a finite number of functions that can be used in an expression?
Expr 1 = Start Date Of Warranty
Expr 5 = End Date Of Warranty
What I started with (11 hard coded dates)
Expr2: IIf([Expr5]<#1/1/2002#,0,IIf([Expr1]>Now(),0,IIf([Expr1]<#1/1/2002# And [Expr5] Between Now() And...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.