No Data Display with year

[Thecherub]

Hello all i hope someone can help me with this?

I've got a Report with 2 subreports.

The main report has Employee Lastname, Firstname, department, and a non visable date field for a Between operation.

The subreports list the Typeofabsence, count, absencedate, and comment
for the History archive, and the currentdata.

The problem is that when i enter a Year in my between i get a Blank report. and if i just enter Month and day i get inacutate data. How can i fix this?

Main Query Code:
SELECT [Employee List].[Last Name], [Employee List].[First Name], [Employee List].Department, [Employee List].[On Substantiation], [Absent Data].Date
FROM [Employee List] INNER JOIN [Absent Data] ON [Employee List].[Employee Number] = [Absent Data].[Employee number]
WHERE ((([Employee List].[Last Name]) Like [Last Name:]) AND (([Absent Data].Date) Between [Start Date] And [End Date:]));

One of the subreports:
SELECT [Employee List].[Last Name], [Employee List].[First Name], [Data Archive].[Type], Count([Data Archive].[Type]) AS CountOfType, [Data Archive].[Date], [Data Archive].[Comment]
FROM [Employee List] INNER JOIN [Data Archive] ON [Employee List].[Employee Number]=[Data Archive].[Employee number]
GROUP BY [Employee List].[Last Name], [Employee List].[First Name], [Data Archive].[Type], [Data Archive].[Date], [Data Archive].[Comment], [Employee List].[Employee Number];

any help would be appreatiated.

and i know that Date is a reserved name and shouldn't be used.

 

[Rich]

Enter the actual dates ?

 

[Thecherub]

???

Enter the actual dates ?

Ok Rich that question throws me....

What i need the reports to show is the range of dates from a start date to an end date. The Database is split into Current 4 months and an archive for and data that is older than that. But the user needs to be able to check a Employees absence history to check for Patterns and to see if Discipline is nessary.