Microsoft document KB/101081 shows how to do this but I can't get it to work. Neither could another member as discussed on thread 27545 (which is no longer accessible, except by internet search).
As my query generated report is fed from three tables I need to use the proposed CODE method outlined in the MS document; using the DLookup method in a query requires a table to be specified.
The CODE method also shows a default value which I need as an initial value for the Reports first row of data. Subsequent rows are then calculated from the previous row - but that's overcomplicating the issue at this initial stage.
Could anyone start me off please?
Pat
As my query generated report is fed from three tables I need to use the proposed CODE method outlined in the MS document; using the DLookup method in a query requires a table to be specified.
The CODE method also shows a default value which I need as an initial value for the Reports first row of data. Subsequent rows are then calculated from the previous row - but that's overcomplicating the issue at this initial stage.
Could anyone start me off please?
Pat