Hi

I have a database that runs all the outstanding warranties.

When i run the report lets say between 01/02/09 and 01/03/09 it will only give me results of warranties entered between 02/02/09 and 28/02/09, it is not including the dates that I actually enter but is between them

Is there something I need to include in the query?

Thanks
R

What is the SQL for the RecordSource of your report?

What is the SQL for the RecordSource of your report?

(((Warranty.GoodRecievedDate)>[Forms]![AMKReportFramework]![AMKDate1] And (Warranty.GoodRecievedDate)<[Forms]![AMKReportFramework]![AMKDate2])

Try using => and =< instead of > and <.

Try using => and =< instead of > and <.
Fabulous thank you very much

you can use the word between as well

(((Warranty.GoodRecievedDate) between [Forms]![AMKReportFramework]![AMKDate1] And [Forms]![AMKReportFramework]![AMKDate2])

the between test includes the days themselves, so it is identical to RG's syntax

Glad we could help.