Report based on date

[seanog2001]

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

 

[boblarson]

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.

 

[GaryPanic]

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

 

[GaryPanic]

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

 

[boblarson]

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)