Search results

Hi there. I just checked with the user and they confirmed that the long list of columns IS indeed necessary. The SQL of the query is in the first thread above (08-24-2012, 02:17 PM). Are you able to use it? Thanks!

Hi - so I have done that and it displays ok. However just to note, that the current MM-YYYY (Calendar) actually displays the date format I need - so it shows 01/01/2012 (Jan 2012), then 01/02/2012 (Feb 2012) etc. Each column in the query is a consolidated month. I need this to be the displayed...

Thanks! Not managing to make this work yet. So to add some more info - within my query, I actually already have a field that shows the first month of sale, so I have been trying to use your advice but excluding the DateDiff logic, as I can just refer the IIF statement to the [First Month of...

Hello All, Hit a bit of a curly one this week. Hoping one of you clever people can help me. I have created a crosstab query to display company sales data and managed to find a tip on the net about how to fill in blanks with Zero's (where we sold nothing that month). This works great however my...

Hi All, Giles here from NZ. I am a reasonably novice user I am sure. Using Access to streamline reporting in my company (I work in Logistics to lots of data to crunch). I like to hit the net with any issues and see who has solved in the past, and grab their ideas. Normally I am pretty good...