Hi all. I have a Report in Access 2003 that includes months and their total. I would like to get a total for the qtr months only. ex. January 1000 February 329 March 873 etc. I am using a query for the recordsource for the report but don't want to put the criterion in the query because I want to get all the months. In the text box control source I put:
=Sum([SumofHrs](IIf([MTH] Between "1" And "2",0))). This returns an error stating SumofHrs undefined. When I put the parenthesis around it and insert an & sign, it gives me a total of all months. ex. =Sum([SumofHrs]) & (IIf([MTH] Between "1" And "2",0)). I just want the first three months. Can anyone help