Please Help! I have a query in an mdb.
one column gives a period number for a specific month. So September would be 9 and October would be 10 for example
another column captures a currency data as month forcast.
the column i would like to create would be “Last Months Forcast”.
Here the query would look at the previous period and display the month forcast currency data in this New column called “Last Months Forcast” current
please help.
Cheers
