Display of Total work in Seperate display field

[mukeshhtrivedi]

I have TYPE field which has 3 data like HEAD, TRACK and PANEL. Now
whenever any person works on HEAD we put 8 Hrs in HRS filed and in
LABOR field it reflects the dollar value automatically like $160
(8*20=160).Now I want to display the total of Head, Track and Panel in
following;

Actual Cost for Head: (All head total should display here if I have
more than one head work)
Actual Cost for Track:(All head total should display here if I have
more than one head track)
Actual Cost for Panel:(All head total should display here if I have
more than one head panel)

I will greatly appreicate if anybody can help me.

Thanks,
Mukesh

[ManningFan]

Create a 'sum' query. Bring in your table and the field "TYPE" and
group by TYPE. Add a new field

ACH: iif([TYPE] = "Head", LABOR, 0)

This will put the total labor in the new field if the TYPE field is
"Head".

Add 2 other similar fields; ACT and ACP and change "Head" to "Track"
and "Panel" respectively.

Sum these fields and you should get a list of the 3 data types and the
total labor for each.
mu************@gmail.com wrote:

I have TYPE field which has 3 data like HEAD, TRACK and PANEL. Now
whenever any person works on HEAD we put 8 Hrs in HRS filed and in
LABOR field it reflects the dollar value automatically like $160
(8*20=160).Now I want to display the total of Head, Track and Panel in
following;

Actual Cost for Head: (All head total should display here if I have
more than one head work)
Actual Cost for Track:(All head total should display here if I have
more than one head track)
Actual Cost for Panel:(All head total should display here if I have
more than one head panel)

I will greatly appreicate if anybody can help me.

Thanks,
Mukesh

[mukeshhtrivedi]

Thanks Manning for your prompt response. Greatly appreciated. I am not
good at access and query. Can you please guide me step by step if you
don't mind. My table name is COSTING. If you can paste the query code I
will greatly appreciate it.

Thanks again,
Mukesh
ManningFan wrote:

Create a 'sum' query. Bring in your table and the field "TYPE" and
group by TYPE. Add a new field

ACH: iif([TYPE] = "Head", LABOR, 0)

This will put the total labor in the new field if the TYPE field is
"Head".

Add 2 other similar fields; ACT and ACP and change "Head" to "Track"
and "Panel" respectively.

Sum these fields and you should get a list of the 3 data types and the
total labor for each.
mu************@gmail.com wrote:

I have TYPE field which has 3 data like HEAD, TRACK and PANEL. Now
whenever any person works on HEAD we put 8 Hrs in HRS filed and in
LABOR field it reflects the dollar value automatically like $160
(8*20=160).Now I want to display the total of Head, Track and Panel in
following;

Actual Cost for Head: (All head total should display here if I have
more than one head work)
Actual Cost for Track:(All head total should display here if I have
more than one head track)
Actual Cost for Panel:(All head total should display here if I have
more than one head panel)

I will greatly appreicate if anybody can help me.

Thanks,
Mukesh

[mukeshhtrivedi]

Hi Manning,
Is there anyway I can display the total of Head in Head display box
Panel in Panel display box and Track in Track display box in my form
without adding new field?

Thanks,
Mukesh
[e-mail] wrote:

Thanks Manning for your prompt response. Greatly appreciated. I am not
good at access and query. Can you please guide me step by step if you
don't mind. My table name is COSTING. If you can paste the query code I
will greatly appreciate it.

Thanks again,
Mukesh
ManningFan wrote:

Create a 'sum' query. Bring in your table and the field "TYPE" and
group by TYPE. Add a new field

ACH: iif([TYPE] = "Head", LABOR, 0)

This will put the total labor in the new field if the TYPE field is
"Head".

Add 2 other similar fields; ACT and ACP and change "Head" to "Track"
and "Panel" respectively.

Sum these fields and you should get a list of the 3 data types and the
total labor for each.
mu************@gmail.com wrote:

I have TYPE field which has 3 data like HEAD, TRACK and PANEL. Now
whenever any person works on HEAD we put 8 Hrs in HRS filed and in
LABOR field it reflects the dollar value automatically like $160
(8*20=160).Now I want to display the total of Head, Track and Panel in
following;

Actual Cost for Head: (All head total should display here if I have
more than one head work)
Actual Cost for Track:(All head total should display here if I have
more than one head track)
Actual Cost for Panel:(All head total should display here if I have
more than one head panel)

I will greatly appreicate if anybody can help me.

Thanks,
Mukesh

[mukeshhtrivedi]

Is there anyway I can display total without addding new field.

Thanks,
Mukesh

mu************@gmail.com wrote:

Hi Manning,
Is there anyway I can display the total of Head in Head display box
Panel in Panel display box and Track in Track display box in my form
without adding new field?

Thanks,
Mukesh
[e-mail] wrote:

Thanks Manning for your prompt response. Greatly appreciated. I am not
good at access and query. Can you please guide me step by step if you
don't mind. My table name is COSTING. If you can paste the query code I
will greatly appreciate it.

Thanks again,
Mukesh
ManningFan wrote:

Create a 'sum' query. Bring in your table and the field "TYPE" and
group by TYPE. Add a new field

ACH: iif([TYPE] = "Head", LABOR, 0)

This will put the total labor in the new field if the TYPE field is
"Head".

Add 2 other similar fields; ACT and ACP and change "Head" to "Track"
and "Panel" respectively.

Sum these fields and you should get a list of the 3 data types and the
total labor for each.
mu************@gmail.com wrote:
> I have TYPE field which has 3 data like HEAD, TRACK and PANEL. Now
> whenever any person works on HEAD we put 8 Hrs in HRS filed and in
> LABOR field it reflects the dollar value automatically like $160
> (8*20=160).Now I want to display the total of Head, Track and Panel in
> following;
>
> Actual Cost for Head: (All head total should display here if I have
> more than one head work)
> Actual Cost for Track:(All head total should display here if I have
> more than one head track)
> Actual Cost for Panel:(All head total should display here if I have
> more than one head panel)
>
> I will greatly appreicate if anybody can help me.
>
> Thanks,
> Mukesh