Global Variables
Posted: Wed May 09, 2007 11:41 am
I am developing reports for an accounting application where we track most recent posting date for a project account. The problem is easy using a "sum" variable to get the max posting date, but that only returns the most recent within the scope or query for the report (only the accounts in the report). I want to use max posting date for the COMPANY in the page header, which would require using the entire table for the sum (max) function or:____LOSCOPE/HIGHSCOPE for a UDF__Lookup to non-linked table to get max value__Parameter passing from a control table which would alread have the max value.____Any Ideas?