Monthly report using criteria

[c8tz]

Hi,

I currently have a report that is made up of a number of different
queries.

The user enters in a start date and end date and it calculates etc. I
would like to expand this so that the query shows for each of the
months in the same query.

ie. Still have the prompt for Start Date and End Date but also have:

If I click on command: Monthly Report - it would show for Jan -- Dec
for that year.

I was thinking appending for each month to a tmp table - but how do i
start off.


Thanks for the help.

 

[Noëlla Gabriël]

Hi,

I suppose you use parameter queries to ask for the start and end dates at
the moment.
If you use a form to let the user fill in the selection crits in text boxes
and start the query from there with a button or so, you can add an unbound
combo box with a list of the months. Once one chooses a month from the
combobox the start and end date can be automatically filled in the criteria
text boxes through the "After update" property.
The query would then be something like:

select field1, field2,........ from myTable where myField between
[forms]![myForm]![dayfrom] and [forms]![myform]![daytill]

 

[c8tz]

Hi,

I suppose you use parameter queries to ask for the start and end dates at
the moment.  
If you use a form to let the user fill in the selection crits in text boxes
and start the query from there with a button or so, you can add an unbound
combo box with a list of the months.  Once one chooses a month from the
combobox the start and end date can be automatically filled in the criteria
text boxes through the "After update" property.
The query would then be something like:

select field1, field2,........ from myTable where myField between
[forms]![myForm]![dayfrom] and [forms]![myform]![daytill]

--
Kind regards
Noëlla

Hi,

I currently have a report that is made up of a number of different
queries.

The user enters in a start date and end date and it calculates etc.  I
would like to expand this so that the query shows for each of the
months in the same query.

ie. Still have the prompt for Start Date and End Date but also have:

If I click on command: Monthly Report - it would show for Jan -- Dec
for that year.

I was thinking appending for each month to a tmp table - but how do i
start off.

Thanks for the help.

Hi,

Thanks for the tip - that's fine .... but I would like for all the
month's data to show. in one query.
so its not for a particular month but for all the months.
Looks like a number of queries...... maybe better to do coding - but
not too confident with the coding.
any other tips how i could do this using queries and tmp tables.

Thanks