CALCULATIONS

  • Thread starter Thread starter Denver
  • Start date Start date
D

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
 
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
 
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
John Spencer said:
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
 
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
John Spencer said:
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
 
thank you John Spencer... it works will now... i just make some modificatins
of those object affected...

thanks again.....

denver

John Spencer said:
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
John Spencer said:
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
 
Back
Top