CALCULATIONS

[Denver]

i have a query bound from a table i have this field..

Qty of Shts Physical Progress Size_value Eqv A Size Earned A Size

i need to this calculation in this field

Eqv A Size Earned A Size
=Size_value*Qty of Shts =Eqv A Size*Physical Progress

this could be possible in Queries but i dont know how make the calculation
in the query?
it is necessary to add another column? but dont want to add column, because
i have now thousands of records. i just want to put the calculation so that
access will do the calculations after clicking desing view again...

hoping someone is kind to help me...

thanks
denver

 

[John Spencer]

One way is to use calculated fields in the query.

In query design view you would enter the following expressions in a blank
field "block". (Don't enter the "Field:" part)

Field: Eqv A Size: Size_Value * [Qty of Sheets]

Field: Earned A Size: Size_Value * [Qty of Sheets] * [Physical Progress]


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Denver]

thank you John Spencer...

the formula is working now...one question john...
does this not affect my reports or other queries or other calculations?

denver

One way is to use calculated fields in the query.

In query design view you would enter the following expressions in a blank
field "block". (Don't enter the "Field:" part)

Field: Eqv A Size: Size_Value * [Qty of Sheets]

Field: Earned A Size: Size_Value * [Qty of Sheets] * [Physical Progress]


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

i have a query bound from a table i have this field..

Qty of Shts Physical Progress Size_value Eqv A Size Earned A Size

i need to this calculation in this field

Eqv A Size Earned A Size
=Size_value*Qty of Shts =Eqv A Size*Physical Progress

this could be possible in Queries but i dont know how make the calculation
in the query?
it is necessary to add another column? but dont want to add column, because
i have now thousands of records. i just want to put the calculation so that
access will do the calculations after clicking desing view again...

hoping someone is kind to help me...

thanks
denver

 

[John Spencer]

This change affects this query. If you are using this query elsewhere it will
flow through to whereever else you are using this query.

If you are using similar expressions in other queries or in other reports then
you will need to make the modifications there.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

thank you John Spencer...

the formula is working now...one question john...
does this not affect my reports or other queries or other calculations?

denver

One way is to use calculated fields in the query.

In query design view you would enter the following expressions in a blank
field "block". (Don't enter the "Field:" part)

Field: Eqv A Size: Size_Value * [Qty of Sheets]

Field: Earned A Size: Size_Value * [Qty of Sheets] * [Physical Progress]


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Denver]

thank you John Spencer... it works will now... i just make some modificatins
of those object affected...

thanks again.....

denver

This change affects this query. If you are using this query elsewhere it will
flow through to whereever else you are using this query.

If you are using similar expressions in other queries or in other reports then
you will need to make the modifications there.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

thank you John Spencer...

the formula is working now...one question john...
does this not affect my reports or other queries or other calculations?

denver

One way is to use calculated fields in the query.

In query design view you would enter the following expressions in a blank
field "block". (Don't enter the "Field:" part)

Field: Eqv A Size: Size_Value * [Qty of Sheets]

Field: Earned A Size: Size_Value * [Qty of Sheets] * [Physical Progress]


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County