Dynamic Queries

[DFINN]

I have tried to develop a dynamic query which will allow me to extract a rolling 12 months of budget data from a table. The table contains the following data: Code, Period (Month), Amount and Year. I need to show this data in a report which will dynamically display the column headings in order of month ie: If the report was generated as of this month it would display data for Mar, Apr, May ....etc.

Thankyou for your help in advance.


[This message has been edited by DFINN (edited 02-26-2002).]

 

[David R]

I think you're looking for a crosstab query. Look them up in Access help or a myriad of articles in the Forum archives.

HTH,
David R

 

[DFINN]

Thanks David for your reply.

I have made use of the crosstab query function, however I seem to be coming unstuck with the order that the query is arranging the columns of months. It is sorting them alphabetically as opposed to the order I need which is dynamic depending on the current month. Any other ideas as I'm starting to get a little frustrated.

 

[David R]

Not having used crosstab queries myself, I can't give you my own answer. However, go to the Search: function of this Forum, and type in 'sort cross tab month'. You'll g et 4 or 5 helpful answers from previous questions.

Good luck,
David R

 

[DFINN]

Thanks David for your help. I've had a look at what has been said in past discussions and I should be able to use their advice to finally implement a solution.

Daniel