create report from date to date

[barakkadosh]

hello i am new hear and i need help
i have 1 table that have 10 fields one of the fields is "date"
i want to make some button that open dialog box when i can make report from 1 date i enter to another date i enter how can i do it
please help

 

[rammudali]

Hi,
better insert to text fields as date and add a button in form. make a query, and in the criteira, refer this fields like ">=[forms]![form1].[txtdt1] And <=[forms]![form1].[txtdt2]" where txtdt1 and txtdt2 are the textfields name and open the report using command button
enjoy

 

[RainLover]

rammudali is correct.

If you have trouble with the syntax of e.g. >= [forms]![form1].[txtdt2]" there is a build capability built into the query.

Just click on the elipse. The three dots ...