Can I enter these formulas in access???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Will I have to enter in a Querie? What should it look like? I know how to do
it in Excel, but this is different.

(STDDEV/[RangMean])*100

([Mean]-[RangMean])/RangMean

Thank You Diane
 
Diane

If you can do this in Excel, why not export the data set from Access to
Excel?

Provided you have a way to calculate the values for [Mean] and [RangMean] in
your query, yes, you can include these as additional fields in an Access
query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I want to see these in a report in Access. But I have not entered
Calculations in Access Queries. Do I but them in there own Querie or the
Querie that my report is based on?
Diane

Jeff Boyce said:
Diane

If you can do this in Excel, why not export the data set from Access to
Excel?

Provided you have a way to calculate the values for [Mean] and [RangMean] in
your query, yes, you can include these as additional fields in an Access
query.

Regards

Jeff Boyce
Microsoft Office/Access MVP


dls25 said:
Will I have to enter in a Querie? What should it look like? I know how to
do
it in Excel, but this is different.

(STDDEV/[RangMean])*100

([Mean]-[RangMean])/RangMean

Thank You Diane
Click to expand...
Click to expand...
 
Diane

Those "formulas" (?formulae?) expect data organized in a particular manner
(i.e., like a spreadsheet). To use one of these in Access, you'd have to
feed the formula the right kind of data.

I believe you can use Totals queries to derive Standard Deviation and Mean,
but your data would have to be structured "vertically" (values in one field,
multiple records), rather than spreadsheetly (multiple columns, one row).

Regards

Jeff Boyce
Microsoft Office/Access MVP

dls25 said:
I want to see these in a report in Access. But I have not entered
Calculations in Access Queries. Do I but them in there own Querie or the
Querie that my report is based on?
Diane

Jeff Boyce said:
Diane

If you can do this in Excel, why not export the data set from Access to
Excel?

Provided you have a way to calculate the values for [Mean] and [RangMean]
in
your query, yes, you can include these as additional fields in an Access
query.

Regards

Jeff Boyce
Microsoft Office/Access MVP


dls25 said:
Will I have to enter in a Querie? What should it look like? I know how
to
do
it in Excel, but this is different.

(STDDEV/[RangMean])*100

([Mean]-[RangMean])/RangMean

Thank You Diane
Click to expand...
Click to expand...
Click to expand...
 
Back
Top