I am having a form with a pivot chart. What I would like to do is for the chart title to take values according to the selection I am making (criteria) and not be static. Any ideas?
Demosthenis
Demosthenis
Last Activity: Nov 23 '21, 08:56 PM
Joined: Nov 6 '08
Location:
-
Access 2003 Pivot chart title dynamic
-
Many apologies. I will take care of it -
Pivot Chart Title Change
Hello,
I am having a form with a pivot chart. What I would like to do is for the chart title to take values according to the sellection I am making (criteria). Any ideas?
Demosthenis Kasastogiannis -
Many thanks for your quick reply.
It is clear now where the problem is. Is it possible in some way to define the logic
"[Query4].[W]=[Query5].[W]"
since this is what I am trying to achieve. - the formula lies in Query 4....Leave a comment:
-
Dlookup issue
Hello,
I am trying to seto up a Dlookup in a query.
My Dlookup field will retrieve data from a second query. The match criteria is the W field. This dlookup up process has to retrieve 24 different values from the second query (Query5). Unfortunatelly the function always brings the first value of the 2nd query for all the 24 fields.
My formula is the
Expr10: IIf([ph4]="Stock4";dLook Up("SumOfExpr2" ;"Query5";"[W]="...
No activity results to display
Leave a comment: