How to build a calculation Querry

  • Thread starter Thread starter mobeer1958
  • Start date Start date
M

mobeer1958

I have a querry now built but I need to take info from one colum. From that
info I need to then select a size in an other colum and mulitiply it by a
factor to produce a seperate colum with this new number. Any help in this is
very appreciated as I am new to this.
 
I have a querry now built but I need to take info from one colum. From that
info I need to then select a size in an other colum and mulitiply it by a
factor to produce a seperate colum with this new number. Any help in this is
very appreciated as I am new to this.
Click to expand...

Put an appropriate expression in a vacant Field cell in the query grid: e.g.
type

Result: [Factor] * [Size]

using your actual fieldnames (which I don't know because you didn't post
them).
 
Ok I'm sorry. What I need to do is look up a specific data from the
"attachment" colum. eg BW,SW,O-Let 0r D-leg. Then I need to find the schedule
it is from the "Schedule" colum eg 3000#,6000#,40,80 etc.Then from the "Size"
colum eg 1,2,4,6,8,etc mulitiply it by a factor from a chart I use to come up
with a new Size to be entered into a new colum "FactoredSize". Thanks for
your time in this matter.

John W. Vinson said:
I have a querry now built but I need to take info from one colum. From that
info I need to then select a size in an other colum and mulitiply it by a
factor to produce a seperate colum with this new number. Any help in this is
very appreciated as I am new to this.
Click to expand...

Put an appropriate expression in a vacant Field cell in the query grid: e.g.
type

Result: [Factor] * [Size]

using your actual fieldnames (which I don't know because you didn't post
them).
Click to expand...
 
Ok I'm sorry. What I need to do is look up a specific data from the
"attachment" colum. eg BW,SW,O-Let 0r D-leg. Then I need to find the schedule
it is from the "Schedule" colum eg 3000#,6000#,40,80 etc.Then from the "Size"
colum eg 1,2,4,6,8,etc mulitiply it by a factor from a chart I use to come up
with a new Size to be entered into a new colum "FactoredSize". Thanks for
your time in this matter.
Click to expand...

Does Access have some way to read this "chart"? or will you read it and type
it into a form, or what?

My GUESS is that you need a table of factors, with a field for the Schedule
and a field for the Size; you can then create a query joining your table to
the Factors table, and calculate the FactoredSize in the query. If the
FactoredSize value can always be derived from the Schedule and the Size, then
you should not store it anywhere in any table; just calculate it on demand as
needed.
 
Back
Top