Report generation with date limitation

[MBA80]

The form I have is for tracking ticket information. Included in the form, are two fields, when the ticket was opened, and when the ticket was closed. This DB is only going to be used for a month. What I would like to do is generate a report that includes all the information on the form, but limit the report to specific dates. In total I would need to create four reports (one for each week in June.) What would be the best way to create a report that only shows information based on the requested week?

[June7]

Not sure what you want.

1. Return records where a specified date falls within the opened and closed dates?

2. Return only records closed in a particular week?

3. Return only records opened in a particular week?

4. Return records that are still open in a particular week? I guess this would be No. 1.

[MBA80]

The main concern for the DB is when the tickets are closed and how many hours of work went in to the ticket. I would want to generate a report that would show the tickets that were closed between M and F of a specific week. If I could create some type of query that could be set up to allow my boss to choose the date ranges he wanted to see, that would probably be best, but again I am very new to all of this.

[June7]

Suggest a form with unbound textbox for entry of data criteria. Then query can refer to the form controls as input parameters.

SELECT * FROM tablename WHERE DateClosed BETWEEN Forms!formname!DateStart AND Forms!formname!DateEnd;

It is possible to enter a single date and then calculate the Mon and Fri dates. http://www.ozgrid.com/forum/showthread.php?t=35005

[MBA80]

I must be confused, or have worded something incorrectly. I would like to have a report available that when my boss clicks on it, he is asked to fill in a date range. For example, when he tries to open the report a box opens and he has to enter the start date of the query, and then another box for the end date of his query. The report then generates information based on the two dates he requested. I already have a core table with all the info he wants, I would just like to give him the flexibility on what dates of information he would like to look at.

You may have already answered how to do that, but I am unfamiliar with how to make a form work in the way you are asking. I have only used them for data entry.

[June7]

Review this tutorial for an example of what I suggested http://datapigtechnologies.com/flash...mtoreport.html