I have a query that returns a set of rows - sorted by part#. On the report I can hide the duplicates (part#). How can I test the part# so that whenever a new part# starts I can reverse image the whole l line. I have not defined any groups. Is this a must?
Sorry I am not understanding your question.
RowCount does not exist, use CountRows instead, then What does 'reversing the image' means.
If you are after counting rows returned by some reports parameters, something along these lines should help.
=iif(CountRows("SM") <= 0,"Your query returned no result.",(iif(CountRows("SM") >= 64500,"Report is too large to open in Excel. Please use CSV Export then use another database like Access. " & "Number of rows returned: " & CountRows("SM") , "Number of rows returned: " & CountRows("SM") )))
Philippe
No comments:
Post a Comment