Help needed inserting formula

[Dhamre]

Hi,

I am new to microsoft access. I am trying to develop a data base that will store data as well as return means and SEMs. I have multiple parameters entered into an access table. The fields are Group Number, MAP, AP, and KV and are stored in a table called "Source Table". I have a query to return the averages for each group, but I am having trouble making a query to return the SEM. the formula for SEM is

SEM = Standard Deviation / (Count ^ (1/2))

This should be easy because access will return Stdev and Count, but when I try and enter the formula into expression builder, all hell breaks loose. Any advice would be greatly appreciated.

Cheers,
DH

 

[Sergeant]

I don't know what SEM is, but this returns a number:

SEM: StDev([MyNumericField])/(Count(*)^(1/2))

 

[Dhamre]

Thanks for that Seargent, I tried pasting it into the query but the statement saying that the specified expression was not part of the aggregate function came up. I'm sure i'm making a soup sandwich out of this, but is there anything else I need to do?

 

[Sergeant]

So, you're putting this into a field in the query grid, and you're replacing MyNumericField with your actual field name?