Here's another option (simplier??) - after you have the parameter query run but before you run the report insert a query that gets the min and max of the parameter date field, link to the results of the parameter query, and in your report header you will say "From [minParameterdate]"...
When I go to edit a chart object in Access (not the sql) I only can see the sample data (i.e., the East, West, North, South and Qtr 1, Qtr2, etc.) making it difficult to change the appearance. I do not see my actual field names but they are in the sql. Then, when I exit Access and go back in...
I tried the code above from Tim Gill (which is awesome by the way) but got a syntax error at the line in the textWrap function listed below:
TextHolder =TextHolder &MyTable(fieldName) &","
Help, anyone? Thanks! I LOVE this website! Lulubelle2
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.