Move data one field to the right- Is this Possible?

[Jax]

I have an Access form with a weekly forecast and I would like to know if it is possible for the amounts to move a field to the right along with their dates.
If this is possible how would I do it?
Example

Weekly Forecast
Date 	    Today	  Today+1 	Today+2 	Today+3	etc..
Amount 1	  1234	    2345	    3456	     4567
Amount 2	    22	     213	     325	      60
Totals	    1256	    2558	    3771	    4627

Tomorrow I would like it to look like this when opened

Weekly Forecast
Date 	Today	Today+1 	Today+2 	Today+3	etc..
Amount 1		   1234	    2345	     3456	
Amount 2		     22	     213	     325	
Totals		     1256	    2558	     3771

This IS NOT Code but I had trouble keeping it in coloums and readable
TIA
Jax

 

[bat17]

I am not sure if it is possible but if it is I would think that you will need to use a Crosstab query. A lot will depend on your data structure. I have not used Crosstabs much, but if you can post details of your table structue someone may be able to point you in the right direction.

Peter

 

[mdmilner]

Write a query that calculates the age of each set of records (rec_date-date).
Use a crosstab using the above query with the above calculated value as column headings.