Recent content by JaySquared

I have many subreports which I am attaching to my main report. The problem is when there is no data in subreport, the subreport header does not show in main report (print preview). Please help :(

Ok my bad. Haven't updated my table yet. You are a genius! thanks for all your posts Mailman!! :D

Was throwing up 'aggregate' warning so I added to GROUP BY aswell: SELECT Year(DateAdd("m",-3,[Request Received Date])) AS FY , Year([Request Received Date]) AS raey , month([Request Received Date]) AS htnom , Count([Project Table].[Request Received Date]) AS tnuoc FROM [Project Table] WHERE...

Ok the only problem I have now is that the query only returns values for one year: raey htnom tnuoc 2013 1 11 2013 2 13 2013 3 17 2013 4 20 2013 5 21 2013 6 25 2013 7 31 2013 8 10 2013 9 21 2013 10 15 2013 11 18 2013 12 6 and also includes Jan-March of that year instead of the following year...

Thank you I will take your advice on board. Just one more thing to help my understanding of SQL - how does the query know to select dates within the current financial year? You did not specify year([Handover or Closed Date]) = Year(Date()). So how does the query manage to do this. It is...

I think that is exactly what I need... in just a few lines of code.. WOW. I have wrote around 13 queries to try and get the same results. I feel pathetic :( I have been using the GUI previously but don't think I will go back to it. SQL is far superior!!:) Knaht Uoy Namliam!!

The 'dead horse' being me I take it?? You're not far from the truth and I have quickly seen the error of my ways as I am getting last FY years results also. :mad: URRRGH!!! I do need the specific months, as I plan to graph these to show the rate of change over the FY. In simple terms I want...

I also realised that my query doesn't work as it should after new years day so added an OR function to the 'WHERE Year' part: SELECT [Project Table].[Handover or Closed Date], Count([Project Table].[Handover or Closed Date]) AS [CountOfHandover or Closed Date] FROM [Project Table] WHERE...

@CJ_London. I tried this but it was not correct. Doesn't limit my query to the financial year just displays all dates before April. Thanks for your suggestion though. JaySquared.

Thanks so much namliam. So glad that there are communities like this for novices like me :D My final code is: SELECT [Project Table].[Handover or Closed Date], Count([Project Table].[Handover or Closed Date]) AS [CountOfHandover or Closed Date] FROM [Project Table] WHERE Year([Handover or...

Thanks namliam, That's great but I need the query to only show dates in the current financial year. Excluding all other dates. This did not seem to work. Cant figure out why this doesn't work: SELECT [Project Table].[Handover or Closed Date], Count([Project Table].[Handover or Closed Date]) AS...

Hi namliam, This looks like what I need. Excuse me but I am totally new to access and SQL in general. Have tried using your second code but access returns warning: 'you tried to execute a query '...' as part of an aggregate function.' Not sure what this means?? PS. thank you for sparing me...

I am creating a query which pulls data from my table and displays a count of the data depending on the month they fall in. I need to pull dates from beginning of FY to end (April - March). I have this for april: SELECT [Project Table].[Handover or Closed Date], Count([Project...