Pulling from prior record

B

Bdavis

I have a query that produces finanial data by clinet and period (month). I'd
like to create an expression to pull a field from the prior period of the
same client so I can calculate variances etc. Example

Client Period Sales Prior Period Sales
AAAA 12-2004 10 20
AAAA 11-2004 20 25
 
Top