Total Sum calculation

[Guest]

Order ID Order Date Ship Date Ship City Shipping Fee
1 11/14/2005 11/15/2005 Jakarta $55.00
2 11/14/2005 11/15/2005 Sydney $76.00
3 11/16/2005 11/17/2005 Sydney $87.00
4 11/17/2005 11/18/2005 Jakarta $43.00
5 11/17/2005 11/18/2005 Paris $105.00

I have a similar data, all I need in my query it should show the total of
the shipping fee for the five order ids. In the design query mode I click the
sigma then on the group by field, I choose SUM, but when I run the query the
result shows without calculated sum but the column heading shows
"sumofshipping"
fee

Also I made a report view of the same and inserted a text box in the
pagefooter with a control source as
=Sum([Amount]) but in that it shows the total shipping fee as $55.00 not
the total sum


whats wrong

Can some one help please

 

[Guest]

In the report, try to put the text box with the Sum in the report footer

The query doesn't sum the records becuase there are different values in the
records that doesn't allow the query to group by, like the Id (1-5) Or the
date.
So it keeping it as single lines
If you want to sum the query, you need to select "Where" for each of the
other fields in the GroupBy section

 

[Guest]

Dear,

In my example, can you please guide me how to do that? I appreciate your
valuable time

Rgds
Shan

In the report, try to put the text box with the Sum in the report footer

The query doesn't sum the records becuase there are different values in the
records that doesn't allow the query to group by, like the Id (1-5) Or the
date.
So it keeping it as single lines
If you want to sum the query, you need to select "Where" for each of the
other fields in the GroupBy section

--
Good Luck
BS"D

Order ID Order Date Ship Date Ship City Shipping Fee
1 11/14/2005 11/15/2005 Jakarta $55.00
2 11/14/2005 11/15/2005 Sydney $76.00
3 11/16/2005 11/17/2005 Sydney $87.00
4 11/17/2005 11/18/2005 Jakarta $43.00
5 11/17/2005 11/18/2005 Paris $105.00

I have a similar data, all I need in my query it should show the total of
the shipping fee for the five order ids. In the design query mode I click the
sigma then on the group by field, I choose SUM, but when I run the query the
result shows without calculated sum but the column heading shows
"sumofshipping"
fee

Also I made a report view of the same and inserted a text box in the
pagefooter with a control source as
=Sum([Amount]) but in that it shows the total shipping fee as $55.00 not
the total sum


whats wrong

Can some one help please

 

[Guest]

If you want to sum by City just leave out the dates.

Dear,

In my example, can you please guide me how to do that? I appreciate your
valuable time

Rgds
Shan

In the report, try to put the text box with the Sum in the report footer

The query doesn't sum the records becuase there are different values in the
records that doesn't allow the query to group by, like the Id (1-5) Or the
date.
So it keeping it as single lines
If you want to sum the query, you need to select "Where" for each of the
other fields in the GroupBy section

--
Good Luck
BS"D

Order ID Order Date Ship Date Ship City Shipping Fee
1 11/14/2005 11/15/2005 Jakarta $55.00
2 11/14/2005 11/15/2005 Sydney $76.00
3 11/16/2005 11/17/2005 Sydney $87.00
4 11/17/2005 11/18/2005 Jakarta $43.00
5 11/17/2005 11/18/2005 Paris $105.00

I have a similar data, all I need in my query it should show the total of
the shipping fee for the five order ids. In the design query mode I click the
sigma then on the group by field, I choose SUM, but when I run the query the
result shows without calculated sum but the column heading shows
"sumofshipping"
fee

Also I made a report view of the same and inserted a text box in the
pagefooter with a control source as
=Sum([Amount]) but in that it shows the total shipping fee as $55.00 not
the total sum


whats wrong

Can some one help please

 

[Guest]

I just need the grand total of the shipping fee

help

If you want to sum by City just leave out the dates.

Dear,

In my example, can you please guide me how to do that? I appreciate your
valuable time

Rgds
Shan

In the report, try to put the text box with the Sum in the report footer

The query doesn't sum the records becuase there are different values in the
records that doesn't allow the query to group by, like the Id (1-5) Or the
date.
So it keeping it as single lines
If you want to sum the query, you need to select "Where" for each of the
other fields in the GroupBy section

--
Good Luck
BS"D


:

Order ID Order Date Ship Date Ship City Shipping Fee
1 11/14/2005 11/15/2005 Jakarta $55.00
2 11/14/2005 11/15/2005 Sydney $76.00
3 11/16/2005 11/17/2005 Sydney $87.00
4 11/17/2005 11/18/2005 Jakarta $43.00
5 11/17/2005 11/18/2005 Paris $105.00

I have a similar data, all I need in my query it should show the total of
the shipping fee for the five order ids. In the design query mode I click the
sigma then on the group by field, I choose SUM, but when I run the query the
result shows without calculated sum but the column heading shows
"sumofshipping"
fee

Also I made a report view of the same and inserted a text box in the
pagefooter with a control source as
=Sum([Amount]) but in that it shows the total shipping fee as $55.00 not
the total sum


whats wrong

Can some one help please

 

[Guest]

Then isn't it just a case of selecting [shipping fee], clicking on the sigma
and choosing "sum" in the totals line?

From your original question that is all it could be.

I just need the grand total of the shipping fee

help

If you want to sum by City just leave out the dates.

Dear,

In my example, can you please guide me how to do that? I appreciate your
valuable time

Rgds
Shan

:

In the report, try to put the text box with the Sum in the report footer

The query doesn't sum the records becuase there are different values in the
records that doesn't allow the query to group by, like the Id (1-5) Or the
date.
So it keeping it as single lines
If you want to sum the query, you need to select "Where" for each of the
other fields in the GroupBy section

--
Good Luck
BS"D


:

Order ID Order Date Ship Date Ship City Shipping Fee
1 11/14/2005 11/15/2005 Jakarta $55.00
2 11/14/2005 11/15/2005 Sydney $76.00
3 11/16/2005 11/17/2005 Sydney $87.00
4 11/17/2005 11/18/2005 Jakarta $43.00
5 11/17/2005 11/18/2005 Paris $105.00

I have a similar data, all I need in my query it should show the total of
the shipping fee for the five order ids. In the design query mode I click the
sigma then on the group by field, I choose SUM, but when I run the query the
result shows without calculated sum but the column heading shows
"sumofshipping"
fee

Also I made a report view of the same and inserted a text box in the
pagefooter with a control source as
=Sum([Amount]) but in that it shows the total shipping fee as $55.00 not
the total sum


whats wrong

Can some one help please

 

[Guest]

There it shows "sumofshipping" as heading and not showing the grand total of
the shipping fee, I made the report view only because of this error but the
report view gives only the first shipping as $55 but all I need the grand
total of the shipping fee.

Whats wrong

help please

Then isn't it just a case of selecting [shipping fee], clicking on the sigma
and choosing "sum" in the totals line?

From your original question that is all it could be.

I just need the grand total of the shipping fee

help

If you want to sum by City just leave out the dates.


:

Dear,

In my example, can you please guide me how to do that? I appreciate your
valuable time

Rgds
Shan

:

In the report, try to put the text box with the Sum in the report footer

The query doesn't sum the records becuase there are different values in the
records that doesn't allow the query to group by, like the Id (1-5) Or the
date.
So it keeping it as single lines
If you want to sum the query, you need to select "Where" for each of the
other fields in the GroupBy section

--
Good Luck
BS"D


:

Order ID Order Date Ship Date Ship City Shipping Fee
1 11/14/2005 11/15/2005 Jakarta $55.00
2 11/14/2005 11/15/2005 Sydney $76.00
3 11/16/2005 11/17/2005 Sydney $87.00
4 11/17/2005 11/18/2005 Jakarta $43.00
5 11/17/2005 11/18/2005 Paris $105.00

I have a similar data, all I need in my query it should show the total of
the shipping fee for the five order ids. In the design query mode I click the
sigma then on the group by field, I choose SUM, but when I run the query the
result shows without calculated sum but the column heading shows
"sumofshipping"
fee

Also I made a report view of the same and inserted a text box in the
pagefooter with a control source as
=Sum([Amount]) but in that it shows the total shipping fee as $55.00 not
the total sum


whats wrong

Can some one help please

 

[Guest]

Use
In code
=DSum("[Shipping Fee]","[TableName]")

In SQL

SELECT Sum([Shipping Fee]) AS SumOfShippingFee
FROM TableName


--
Good Luck
BS"D

There it shows "sumofshipping" as heading and not showing the grand total of
the shipping fee, I made the report view only because of this error but the
report view gives only the first shipping as $55 but all I need the grand
total of the shipping fee.

Whats wrong

help please

Then isn't it just a case of selecting [shipping fee], clicking on the sigma
and choosing "sum" in the totals line?

From your original question that is all it could be.

I just need the grand total of the shipping fee

help


:


If you want to sum by City just leave out the dates.


:

Dear,

In my example, can you please guide me how to do that? I appreciate your
valuable time

Rgds
Shan

:

In the report, try to put the text box with the Sum in the report footer

The query doesn't sum the records becuase there are different values in the
records that doesn't allow the query to group by, like the Id (1-5) Or the
date.
So it keeping it as single lines
If you want to sum the query, you need to select "Where" for each of the
other fields in the GroupBy section

--
Good Luck
BS"D


:

Order ID Order Date Ship Date Ship City Shipping Fee
1 11/14/2005 11/15/2005 Jakarta $55.00
2 11/14/2005 11/15/2005 Sydney $76.00
3 11/16/2005 11/17/2005 Sydney $87.00
4 11/17/2005 11/18/2005 Jakarta $43.00
5 11/17/2005 11/18/2005 Paris $105.00

I have a similar data, all I need in my query it should show the total of
the shipping fee for the five order ids. In the design query mode I click the
sigma then on the group by field, I choose SUM, but when I run the query the
result shows without calculated sum but the column heading shows
"sumofshipping"
fee

Also I made a report view of the same and inserted a text box in the
pagefooter with a control source as
=Sum([Amount]) but in that it shows the total shipping fee as $55.00 not
the total sum


whats wrong

Can some one help please