I want to create a report where it will generated details on data in my db Dependant on a data enter by the user.

You can create a form which has two text boxes for the dates (from and to) and then create a query which, in the criteria, references them

Between Forms!YourMainForm.TextBoxFrom And Forms!YourMainForm.TextBoxTo

Then, create the report based on the query.

base you report on qry

in this should be date field (yes )

many ways of doing this but my faviourate is
have a form call XXXX or whatever
on this form use the wizard to do your report
and put a from and to date on this form
now in your qry
in the date field put
between forms!xxxxx!from and forms!xxxx!to

xxxx = the name of your form
from is the name of the date field to is the other one

now if it just 1 date
put on your qry forms!xxxx!finddate

finddate would be the field name on your form which would be 1 date only

basically you are telling the qry where to look for the filter

bob -- beat me 2 it again (its the weekend)

your text boxs might need formating

uk style would be dd/mm/yyyy but whatever your date iis in your underling table try to match it


g

Gary: It's not my weekend yet though. It's only 2:19pm on Friday for me. (I just like to take short mental breaks while working and check the forum when I do)