Query help

[manich1]

Hi
I want to find the average taken from the DB "sold" field divided by 12. and in the same query find the average greater than or equal to 500,from suppliers FPC and MBM.



In design view....

Is this correct,

"Average" field heading = Average:[ sold/12 ]

"criteria" Field = >= 500

"or" Field = Like "*FPC" and "MBM"

Not sure about spaces between characters,Any advice greatly appreciated.

Mark

[orange]

If it's just a select query, then no changes will be made. Try it, adjust as needed. Post back with results/questions.