C
CEV
I have a query that shows records of employees in every position for the
fiscal year 7/1/2006 through 6/30/2007. If more than one employee has been
in that position during the year, it would show both. What I did was request
the data by asking for start dates during the fiscal year. However this will
not show employees or positions for the employees that started before
7/1/2006 but were still in the position as of that date. I hope I have
explained my issue well enough and that someone can help me out.
My Query is as follows:
PositionNumber from tblEmployeePosition
EmployeeNumber from tblEmployeePosition
LastName from tblEmployees
FirstName from tblEmployees
DateStarted from tblEmployeePosition
DateEnded from tblEmployeePosition
DateStarted has a criteria of Between [Forms]![frmReports]![txtBeginDate]
And [Forms]![frmReports]![txtEndDate]
Thanks,
Chad
fiscal year 7/1/2006 through 6/30/2007. If more than one employee has been
in that position during the year, it would show both. What I did was request
the data by asking for start dates during the fiscal year. However this will
not show employees or positions for the employees that started before
7/1/2006 but were still in the position as of that date. I hope I have
explained my issue well enough and that someone can help me out.
My Query is as follows:
PositionNumber from tblEmployeePosition
EmployeeNumber from tblEmployeePosition
LastName from tblEmployees
FirstName from tblEmployees
DateStarted from tblEmployeePosition
DateEnded from tblEmployeePosition
DateStarted has a criteria of Between [Forms]![frmReports]![txtBeginDate]
And [Forms]![frmReports]![txtEndDate]
Thanks,
Chad