Print group totals at then end of a report

[Guest]

I have a report that prints the Product Class Sales for a date range
specified by the user (as criteria in the query). The quantity, sales amount,
margin and margin percentage are sums, gropued by customer, by product class.

What I'd like to add to the end of the report (in the report footer
section?) is to list each of the product classes and show the above product
class totals for all the customers overall.

I thought of using a separate query, but that way the user would have to
enter the start and end dates twice. I tried using running totals but I'm not
getting correct results. Is there a way to do this?

 

[Guest]

Use two queries but include the date entry prompt in the ouput.

In the totals query grid Field add columns X:[Enter start date]
Y:[Enter end date]

Copy and paste the prompts as criteria (if you copy & paste you won't get a
typo).

In the second query add the table and the first query and join.

 

[Guest]

So in the first query, I leave the start and end date prompts as criteria,
and add two fields X and Y to that same query, defining them exactly the same
as the criteria prompt. Correct so far?

I'm not sure what you mean by "In the second query add the table and the
first query and join." I've never used a query in a query (if I'm
understanding what you're saying). Can you please give an example? Thanks for
your help.
--
Minnie

Use two queries but include the date entry prompt in the ouput.

In the totals query grid Field add columns X:[Enter start date]
Y:[Enter end date]

Copy and paste the prompts as criteria (if you copy & paste you won't get a
typo).

I have a report that prints the Product Class Sales for a date range
specified by the user (as criteria in the query). The quantity, sales amount,
margin and margin percentage are sums, gropued by customer, by product class.

What I'd like to add to the end of the report (in the report footer
section?) is to list each of the product classes and show the above product
class totals for all the customers overall.

I thought of using a separate query, but that way the user would have to
enter the start and end dates twice. I tried using running totals but I'm not
getting correct results. Is there a way to do this?

 

[Guest]

I made a mistake - you do not join them
In design view of the query click on the tool bar icon for tables (it has a
yellow plus sign and a grid) and pull down (or double click) the table and
the first query.

So in the first query, I leave the start and end date prompts as criteria,
and add two fields X and Y to that same query, defining them exactly the same
as the criteria prompt. Correct so far?

I'm not sure what you mean by "In the second query add the table and the
first query and join." I've never used a query in a query (if I'm
understanding what you're saying). Can you please give an example? Thanks for
your help.
--
Minnie

Use two queries but include the date entry prompt in the ouput.

In the totals query grid Field add columns X:[Enter start date]
Y:[Enter end date]

Copy and paste the prompts as criteria (if you copy & paste you won't get a
typo).

I have a report that prints the Product Class Sales for a date range
specified by the user (as criteria in the query). The quantity, sales amount,
margin and margin percentage are sums, gropued by customer, by product class.

What I'd like to add to the end of the report (in the report footer
section?) is to list each of the product classes and show the above product
class totals for all the customers overall.

I thought of using a separate query, but that way the user would have to
enter the start and end dates twice. I tried using running totals but I'm not
getting correct results. Is there a way to do this?

 

[Guest]

I have the second query working now thanks to your help. Now I want to print
the results in the report footer section of the report that has already been
set up to run off of the first query.

When I add a new text box to the report footer and use (for example)
qrySecond.PRODCLS as the control source, I get a message telling me that
"This control has an invalid control source". When I use the search option
the only fields that are listed are the fields from the first query.

How do I get it to recognize the second query also? Please give detailed
instructions, if you could. I have never used two queries in a report before.
Thanks.
--
Minnie

I made a mistake - you do not join them
In design view of the query click on the tool bar icon for tables (it has a
yellow plus sign and a grid) and pull down (or double click) the table and
the first query.

So in the first query, I leave the start and end date prompts as criteria,
and add two fields X and Y to that same query, defining them exactly the same
as the criteria prompt. Correct so far?

I'm not sure what you mean by "In the second query add the table and the
first query and join." I've never used a query in a query (if I'm
understanding what you're saying). Can you please give an example? Thanks for
your help.
--
Minnie

Use two queries but include the date entry prompt in the ouput.

In the totals query grid Field add columns X:[Enter start date]
Y:[Enter end date]

Copy and paste the prompts as criteria (if you copy & paste you won't get a
typo).



:

I have a report that prints the Product Class Sales for a date range
specified by the user (as criteria in the query). The quantity, sales amount,
margin and margin percentage are sums, gropued by customer, by product class.

What I'd like to add to the end of the report (in the report footer
section?) is to list each of the product classes and show the above product
class totals for all the customers overall.

I thought of using a separate query, but that way the user would have to
enter the start and end dates twice. I tried using running totals but I'm not
getting correct results. Is there a way to do this?

 

[Guest]

You have to use the 2nd query as your report source.

I have the second query working now thanks to your help. Now I want to print
the results in the report footer section of the report that has already been
set up to run off of the first query.

When I add a new text box to the report footer and use (for example)
qrySecond.PRODCLS as the control source, I get a message telling me that
"This control has an invalid control source". When I use the search option
the only fields that are listed are the fields from the first query.

How do I get it to recognize the second query also? Please give detailed
instructions, if you could. I have never used two queries in a report before.
Thanks.
--
Minnie

I made a mistake - you do not join them
In design view of the query click on the tool bar icon for tables (it has a
yellow plus sign and a grid) and pull down (or double click) the table and
the first query.

So in the first query, I leave the start and end date prompts as criteria,
and add two fields X and Y to that same query, defining them exactly the same
as the criteria prompt. Correct so far?

I'm not sure what you mean by "In the second query add the table and the
first query and join." I've never used a query in a query (if I'm
understanding what you're saying). Can you please give an example? Thanks for
your help.
--
Minnie


:

Use two queries but include the date entry prompt in the ouput.

In the totals query grid Field add columns X:[Enter start date]
Y:[Enter end date]

Copy and paste the prompts as criteria (if you copy & paste you won't get a
typo).



:

I have a report that prints the Product Class Sales for a date range
specified by the user (as criteria in the query). The quantity, sales amount,
margin and margin percentage are sums, gropued by customer, by product class.

What I'd like to add to the end of the report (in the report footer
section?) is to list each of the product classes and show the above product
class totals for all the customers overall.

I thought of using a separate query, but that way the user would have to
enter the start and end dates twice. I tried using running totals but I'm not
getting correct results. Is there a way to do this?

 

[Guest]

Having done that, when I try to run the report a message dispalys that says:
The specified field '[tblSA-DETD].PRODCLS' could refer to more than one table
listed in the from clause of your SQL statement.

In the detail section of the report, the control source for Product Class is
qrySACustByPC.PRODCLS, whereas in the report footer the control source for
Product Class is tblSA-DETD.PRODCLS. Both of these fields became available
when I changed the report's control source to the second query.

I would need to list the product class in both the detail and report footer
sections, but it woun't let me do that.

--
Minnie

You have to use the 2nd query as your report source.

I have the second query working now thanks to your help. Now I want to print
the results in the report footer section of the report that has already been
set up to run off of the first query.

When I add a new text box to the report footer and use (for example)
qrySecond.PRODCLS as the control source, I get a message telling me that
"This control has an invalid control source". When I use the search option
the only fields that are listed are the fields from the first query.

How do I get it to recognize the second query also? Please give detailed
instructions, if you could. I have never used two queries in a report before.
Thanks.
--
Minnie

I made a mistake - you do not join them
In design view of the query click on the tool bar icon for tables (it has a
yellow plus sign and a grid) and pull down (or double click) the table and
the first query.



:

So in the first query, I leave the start and end date prompts as criteria,
and add two fields X and Y to that same query, defining them exactly the same
as the criteria prompt. Correct so far?

I'm not sure what you mean by "In the second query add the table and the
first query and join." I've never used a query in a query (if I'm
understanding what you're saying). Can you please give an example? Thanks for
your help.
--
Minnie


:

Use two queries but include the date entry prompt in the ouput.

In the totals query grid Field add columns X:[Enter start date]
Y:[Enter end date]

Copy and paste the prompts as criteria (if you copy & paste you won't get a
typo).



:

I have a report that prints the Product Class Sales for a date range
specified by the user (as criteria in the query). The quantity, sales amount,
margin and margin percentage are sums, gropued by customer, by product class.

What I'd like to add to the end of the report (in the report footer
section?) is to list each of the product classes and show the above product
class totals for all the customers overall.

I thought of using a separate query, but that way the user would have to
enter the start and end dates twice. I tried using running totals but I'm not
getting correct results. Is there a way to do this?

 

[jean-pierre devillard]

Having done that, when I try to run the report a message dispalys that
says:
The specified field '[tblSA-DETD].PRODCLS' could refer to more than one
table
listed in the from clause of your SQL statement.

In the detail section of the report, the control source for Product Class
is
qrySACustByPC.PRODCLS, whereas in the report footer the control source for
Product Class is tblSA-DETD.PRODCLS. Both of these fields became available
when I changed the report's control source to the second query.

I would need to list the product class in both the detail and report
footer
sections, but it woun't let me do that.

--
Minnie

You have to use the 2nd query as your report source.

I have the second query working now thanks to your help. Now I want to
print
the results in the report footer section of the report that has already
been
set up to run off of the first query.

When I add a new text box to the report footer and use (for example)
qrySecond.PRODCLS as the control source, I get a message telling me
that
"This control has an invalid control source". When I use the search
option
the only fields that are listed are the fields from the first query.

How do I get it to recognize the second query also? Please give
detailed
instructions, if you could. I have never used two queries in a report
before.
Thanks.
--
Minnie


:

I made a mistake - you do not join them
In design view of the query click on the tool bar icon for tables (it
has a
yellow plus sign and a grid) and pull down (or double click) the
table and
the first query.



:

So in the first query, I leave the start and end date prompts as
criteria,
and add two fields X and Y to that same query, defining them
exactly the same
as the criteria prompt. Correct so far?

I'm not sure what you mean by "In the second query add the table
and the
first query and join." I've never used a query in a query (if I'm
understanding what you're saying). Can you please give an example?
Thanks for
your help.
--
Minnie


:

Use two queries but include the date entry prompt in the ouput.

In the totals query grid Field add columns X:[Enter start
date]
Y:[Enter end date]

Copy and paste the prompts as criteria (if you copy & paste you
won't get a
typo).



:

I have a report that prints the Product Class Sales for a date
range
specified by the user (as criteria in the query). The quantity,
sales amount,
margin and margin percentage are sums, gropued by customer, by
product class.

What I'd like to add to the end of the report (in the report
footer
section?) is to list each of the product classes and show the
above product
class totals for all the customers overall.

I thought of using a separate query, but that way the user
would have to
enter the start and end dates twice. I tried using running
totals but I'm not
getting correct results. Is there a way to do this?

 

[Guest]

The last reply from jean-pierre was blank.......?
--
Minnie

Having done that, when I try to run the report a message dispalys that
says:
The specified field '[tblSA-DETD].PRODCLS' could refer to more than one
table
listed in the from clause of your SQL statement.

In the detail section of the report, the control source for Product Class
is
qrySACustByPC.PRODCLS, whereas in the report footer the control source for
Product Class is tblSA-DETD.PRODCLS. Both of these fields became available
when I changed the report's control source to the second query.

I would need to list the product class in both the detail and report
footer
sections, but it woun't let me do that.

--
Minnie

You have to use the 2nd query as your report source.

:

I have the second query working now thanks to your help. Now I want to
print
the results in the report footer section of the report that has already
been
set up to run off of the first query.

When I add a new text box to the report footer and use (for example)
qrySecond.PRODCLS as the control source, I get a message telling me
that
"This control has an invalid control source". When I use the search
option
the only fields that are listed are the fields from the first query.

How do I get it to recognize the second query also? Please give
detailed
instructions, if you could. I have never used two queries in a report
before.
Thanks.
--
Minnie


:

I made a mistake - you do not join them
In design view of the query click on the tool bar icon for tables (it
has a
yellow plus sign and a grid) and pull down (or double click) the
table and
the first query.



:

So in the first query, I leave the start and end date prompts as
criteria,
and add two fields X and Y to that same query, defining them
exactly the same
as the criteria prompt. Correct so far?

I'm not sure what you mean by "In the second query add the table
and the
first query and join." I've never used a query in a query (if I'm
understanding what you're saying). Can you please give an example?
Thanks for
your help.
--
Minnie


:

Use two queries but include the date entry prompt in the ouput.

In the totals query grid Field add columns X:[Enter start
date]
Y:[Enter end date]

Copy and paste the prompts as criteria (if you copy & paste you
won't get a
typo).



:

I have a report that prints the Product Class Sales for a date
range
specified by the user (as criteria in the query). The quantity,
sales amount,
margin and margin percentage are sums, gropued by customer, by
product class.

What I'd like to add to the end of the report (in the report
footer
section?) is to list each of the product classes and show the
above product
class totals for all the customers overall.

I thought of using a separate query, but that way the user
would have to
enter the start and end dates twice. I tried using running
totals but I'm not
getting correct results. Is there a way to do this?