Can I use a public variable in a group footer section in report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to get a conditional summary which is judged by the condition from
another 2 tables, I wrote a procedure to process the whole judge and
calculation thing, passed the result to a public variable, but in the group
footer section, it seems like it couldn't recognize the variable, how can I
do it then?

any help would be great, thanks a lot in advance!
 
If I understand correctly, you can create a public function that returns
your variable. Then use the function where you need the value from the
memory variable:

Public Function GetMyVar() as String
GetMyVar = pstrMyVariable
End Function
 
Back
Top