include dates

[rkaria]

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

 

[RuralGuy]

What is the SQL for the RecordSource of your report?

 

[rkaria]

What is the SQL for the RecordSource of your report?

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

 

[RuralGuy]

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

 

[rkaria]

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

Fabulous thank you very much

 

[gemma-the-husky]

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

 

[RuralGuy]

Glad we could help.