Reporting on selected information

[Rich Mogy]

I have a database that has many locations, with sales by detail by product
and date, location, etc.
I have designed a report that reports sales by product and location and now
want to selection by location.

I am at a loss -- can't figure out the steps necessary to limit my report
and am getting confused by the instructions in help.

Any help, with a reasonable amount of detail, would be appreciated. I'm
sure it's simple, but driving me crazy.

Rich

 

[Joseph Meehan]

I have a database that has many locations, with sales by detail by
product and date, location, etc.
I have designed a report that reports sales by product and location
and now want to selection by location.

I am at a loss -- can't figure out the steps necessary to limit my
report and am getting confused by the instructions in help.

Any help, with a reasonable amount of detail, would be appreciated. I'm
sure it's simple, but driving me crazy.

Rich

Tell us a little more. How are you going to provide the criteria for
the location? Do you want Access to ask for it each time you run the report
or do you want to have it set up to be the same, maybe different reports for
different locations, or print all locations but a new page for each
location?

 

[Rich Mogy]

I would like Access to ask for it each time I run the report.

 

[Joseph Meehan]

I would like Access to ask for it each time I run the report.
news:[email protected]...

Assuming the report is based on a query:

In the "Criteria" row of the query in the Location field column type:
[Enter Location] with the brackets.

When you run the report based on this query it will ask for input and
display the massage "Enter Location"

 

[Rich Mogy]

Like I said, I'm a novice -- how do I get the report to be based on a
query -- that is where I'm lost.

RM

I would like Access to ask for it each time I run the report.
news:[email protected]...

Assuming the report is based on a query:

In the "Criteria" row of the query in the Location field column type:
[Enter Location] with the brackets.

When you run the report based on this query it will ask for input and
display the massage "Enter Location"

 

[Joseph Meehan]

Like I said, I'm a novice -- how do I get the report to be based on a
query -- that is where I'm lost.

There are many paths, but try this one. First make sure you have a
query with the data in it. You can make one from the table and just include
all the fields you use in the report.

Next open the report in design mode and right click on the report.
Select properties. Then select the data tab and then select the name of the
query. Assuming all of the fields are there, it should all work.

As long as you follow the instructions this is rather safe as you can
always return the record source (data) to what it was.

RM

I would like Access to ask for it each time I run the report.
news:[email protected]...

Assuming the report is based on a query:

In the "Criteria" row of the query in the Location field column
type: [Enter Location] with the brackets.

When you run the report based on this query it will ask for input
and display the massage "Enter Location"

Rich Mogy wrote:
I have a database that has many locations, with sales by detail by
product and date, location, etc.
I have designed a report that reports sales by product and
location and now want to selection by location.

I am at a loss -- can't figure out the steps necessary to limit my
report and am getting confused by the instructions in help.

Any help, with a reasonable amount of detail, would be
appreciated. I'm sure it's simple, but driving me crazy.

Rich

Tell us a little more. How are you going to provide the
criteria for the location? Do you want Access to ask for it each
time you run the report or do you want to have it set up to be the
same, maybe different reports for different locations, or print all
locations but a new page for each location?

 

[Rich Mogy]

Thanks, that's exactly what I was looking for.

Like I said, I'm a novice -- how do I get the report to be based on a
query -- that is where I'm lost.

There are many paths, but try this one. First make sure you have a
query with the data in it. You can make one from the table and just
include all the fields you use in the report.

Next open the report in design mode and right click on the report.
Select properties. Then select the data tab and then select the name of
the query. Assuming all of the fields are there, it should all work.

As long as you follow the instructions this is rather safe as you can
always return the record source (data) to what it was.

RM

Rich Mogy wrote:
I would like Access to ask for it each time I run the report.

Assuming the report is based on a query:

In the "Criteria" row of the query in the Location field column
type: [Enter Location] with the brackets.

When you run the report based on this query it will ask for input
and display the massage "Enter Location"



Rich Mogy wrote:
I have a database that has many locations, with sales by detail by
product and date, location, etc.
I have designed a report that reports sales by product and
location and now want to selection by location.

I am at a loss -- can't figure out the steps necessary to limit my
report and am getting confused by the instructions in help.

Any help, with a reasonable amount of detail, would be
appreciated. I'm sure it's simple, but driving me crazy.

Rich

Tell us a little more. How are you going to provide the
criteria for the location? Do you want Access to ask for it each
time you run the report or do you want to have it set up to be the
same, maybe different reports for different locations, or print all
locations but a new page for each location?

 

[Joseph Meehan]

Thanks, that's exactly what I was looking for.

Thanks for letting me know it worked.