Search for date form date to date ‎

[aamm]

I have data with a lot of recorded and report , I wont to create a form to select the report ‎name and the date form to.‎

Could you please help me in this regards ‎

 

[thisisntwally]

dude, let me be the first to say that this post doesn't really make much sense.

Could you please help me in this regards


I have data with a lot of recorded and report , I wont to create a form to select the report ‎name and the date form to.‎

"i have data with a lot of (records?) and report(s), I w(a)nt to create a form to select report name and (the date also? the date from two?)"

Are you trying to make a form which will display report names and dates, between two given dates?

 

[aamm]

I have records for different month and I wont to search for this record in different ‎element Location , Staff , ……. I already have this element as report .So I need drop ‎down menu to select the report name then I select the date I wish to get the report for ‎‎(01/08/2007 to 31/08/2007)‎

 

[thisisntwally]

are you trying to search for records or for Reports?

 

[aamm]

I wont to print or extract a report for period of time

 

[thisisntwally]

assuming you already have the report built, you need to build a query/SQL statement which will select the data from your tables, as specified in your form, and use this as the source for your report.

 

[aamm]

how ?? step by step . I'm new on this

 

[thisisntwally]

1. build a form, name it frmRetlaw
2. add two text, name them after and before
a. set format as date
3. add button
4. search this forum for keywords like Report Form Dates and Query.

Im not going to write out everything for you, because i don't know anything about the structure of your database. But as I understand it you have two options.
1. You can build a query which selects everything and filter it.
or
2. build a query based on your form which will be something like this:

SELECT tblWont.Name, tblWont.Date
FROM tblWont
WHERE (tblWont.Date) Between [forms]![frmRetlaw]![after] And [forms]![frmRetlaw]![before])

you can either write this out, or build it in the query GUI

set this as your reports recordsource.

set the button on frmRetlaw to open your report on click