Hi. Here I attached two access files. Each one has a report and both reports have a textbox in their Report Headers with the same function. One work normal but another one shows ERROR. I want to find and know what is wrong in second file. Please don't post advices like using function in query as I know it. Please find cause of error. Thanks for your time.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
max function in report 1
- Thread starter saqassemi
- Start date
-
1
- #2
There seems to be limited length of argument(s?) in formula (255 characters?). If you divide your formula to sum of two Max functions, it works.
In this case you can use =Max[countScores]) instead, that is already calculated for each entry in query.
combo
In this case you can use =Max[countScores]) instead, that is already calculated for each entry in query.
combo
- Status
Similar threads
- Locked
- Question
