Recent content by Noodlestall

Cronk that was exactly what I needed and worked perfectly. Thanks.

Hopefully I can explain my problem properly after thinking about it a bit more. I have the following tables: name: Team - which contains TeamName - String Department1 - String Department2 - String Month - Integer Year - Integer Another table name: RAGStatusTbl TeamName - String RAGStatus -...

I want to use the crosstab to create a report where the 'DisplayDate' are the column headers. My understanding is that the column headers in the crosstab auto order alphabetically. I was hoping that I could somehow join the crosstab to the Dates table, order the columns by the rolling month...

Hi, I have attached a document with screenshots of the tables and query outputs. Thanks

I am trying to create a Rolling Month report for the past 3 months. I have 3 tables RAGvalues TeamValues Dates These are used to create a table with the data that I require TeamNumber | RAGMonth | RAGYear | RAG | RollingMonth | DisplayDate Team1 | 1 | 2018 | R | 13 | Jan-2018 Team2 | 2 | 2018...