Access Reports

[Guest]

Hope this is the correct place to post this question. I have a query of
issues submited and resolved, what I would like to do is have the query
display only those issues submitted and or resolved for a particular month,
"without" having to change the criteria monthly. This is basically and
inventory in/out query which feeds a report, any suggestions? Right now I
have those two fields with "between" criteria.

As for the report, I want the report header to display the actual month that
coincides with the query data. I can get the correct month to display with my
current expression, but because of my issues with the query, I don't get the
correct information.

So, in a nutshell, I want monthly submitted and resolved in a query, and
generate a report based on the monthly information, 'without" changing the
query criteria each month.

Sorry so long, and thanks in advance for any assistance.

KenE

 

[Carl Rapson]

Hope this is the correct place to post this question. I have a query of
issues submited and resolved, what I would like to do is have the query
display only those issues submitted and or resolved for a particular
month,
"without" having to change the criteria monthly. This is basically and
inventory in/out query which feeds a report, any suggestions? Right now I
have those two fields with "between" criteria.

As for the report, I want the report header to display the actual month
that
coincides with the query data. I can get the correct month to display with
my
current expression, but because of my issues with the query, I don't get
the
correct information.

So, in a nutshell, I want monthly submitted and resolved in a query, and
generate a report based on the monthly information, 'without" changing the
query criteria each month.

Sorry so long, and thanks in advance for any assistance.

KenE

One way to do this is to create a form that contains textbox controls for
the user to input the desired date range. Modify your query to remove the
date criteria. From the form, open the report passing the date range in the
WhereCondition parameter. You could pass the name of the month in the
OpenArgs parameter, which the report can pick up and use to modify a textbox
in the title.

Carl Rapson

 

[Guest]

Thanks Carl this suggestion makes much more sense in that the user can define
what period of time they want reported, I'll give this a try--