Employee Attendance Year View

[CaptR]

Re: Color Calendar Current Day and att code
Sorry, I am new here and hope I have the right place, but I have been modifying the file Employee Attendance Year View. Have it intigrated with our database and works great but cannot find where to modify it to run on a fiscal year of 1 April. We run on a fiscal year starting 1 April until 30 March. Any ideas?

I have searched all the area for Fiscal year and have great ideas but being a real noobie I am totally confused as to where to use these ideas. Have tried to work with each qry and rpt with success but cannot find any idea on the calendar itself. The numbers totalling up the absences are all fiscal year, cannot get it to change.

I'm, rambling and just want to say thankyou for all that have worked on this file to get it to where it is today, so that newbies like myself can learn so much.

Thanx in advance.

 

[missinglinq]

First off, what is the file Employee Attendance Year View? Is this a template database provided with Access 2007? A template you've downloaded from somewhere else?

 

[CaptR]

It is a database that was dowloaded from here. I believe the original was from oxicottin (or similar name), sorry if I didn't spell it right.

 

[CaptR]

Okay, I'm at wits end. I have searched and searched and don't know where to go.

In the above database there are totals on the calendar form. Now the problem is I need the total to show from a calendar year starting 1 April XX to 30 March X1.

The code I'm looking at is
' Vacation YTD
strSql = "SELECT Count(InputID) AS TotDays FROM tblInput "
strSql = strSql & "WHERE ((Format([InputDate], 'yyyy')=" & CInt(gstrYear) & ") AND ((tblInput.UserID)=" & glngUserID & ") AND ((tblInput.InputText)='Vacation'));"
Set rs = db.OpenRecordset(strSql, dbOpenSnapshot)
frm!txtVacYTD = rs!TotDays
rs.Close
strSql = "'"

I'm sure it is with the CInt (gstrYear) but can't figure out how to modify this. I've tried functions just about everything. Can anybody help?

Thanx in advance.