Parameters (Date Range) not working

[smarty84handsome]

I have created a query for report which has two parameters i.e. "Date from" and "Date To" which is suppose to help me show the data in a particular date range. The data is pulled from the table when given the desired date range. But somehow this is not working........can someone help me with this ?

[JoeM]

Can you post the SQL code of your query?

[smarty84handsome]

SELECT [Discrepancy Table].Amount, [Discrepancy Table].[Over/Short], [Discrepancy Table].Explanation, [Discrepancy Table].Type, [Discrepancy Table].Status, [Employee File].Employee_Number, [Employee File].Employee_Name, [Discrepancy Table].[TSSR Date]
FROM [Employee File] INNER JOIN [Discrepancy Table] ON [Employee File].[Sr No] = [Discrepancy Table].[Emp ID]
WHERE ((([Employee File].Employee_Number)=[Enter Employee Number]) AND (([Discrepancy Table].[TSSR Date])=[Enter Date From] And ([Discrepancy Table].[TSSR Date])=[Enter Date To]));


I want 'TSSR Date from' and 'TSSR Date to' to be my parameter when i open report and this is not working.

[JoeM]

If you are entering different From and To Dates, how can [TSSR Date] be equal to two different dates at the same time?
It cannot. So your query will never return anything unless you enter the same date for both criteria.

You need to change it to:

 AND (([Discrepancy Table].[TSSR Date])>=[Enter Date From] And ([Discrepancy Table].[TSSR Date])<=[Enter Date To]));

or use BETWEEN, i.e.

([Discrepancy Table].[TSSR Date] BETWEEN [Enter Date From] AND [Enter Date To])

[smarty84handsome]

Great it is working now.