Web Development

You haven't said what your source data looks like. I assume that there is a date field and the user would enter on the form the starting and ending dates of the period of interest, then click on the button to run the report.

Note: If your sourcedata does not have a date field, then you have a problem, since the text (like the text in the sample you listed) does not sort properly.

If the controls on your form are txtStart and txtEnd, you could either base the report on a query that wouldinclude the criteria for the date field as between txtStart and txtEnd (you can let the query builder build the correct syntax to refer to your form).

What is the report based on? A select query or a cross-tab query? What are the columns on thereport? (Example: Division, Group, month1, month2, month3, (through month12), total) If the month headings can change (like a running 12 month report), then producing the report can be tricky, but possible with unbound controls and a separate grouping query to get the date range. I've done this and it's possible, but a pain to create.

This question was closed by the author