calculating a division

  • Thread starter Thread starter Manos
  • Start date Start date
M

Manos

Dear all
i have a table with 3 field
the first one is the name (text), the other one is Games
(number) nad the other one is the number of balls (number)

i would like to create a query that will calculate the
average by dividing the games by the number of balls

I create a query and i have alreade tried the build
functions in order to create a creteria but i don't have
any result, it gives my nothing

Does anyone have an idea on that?
i am using the office xp edition

Thanks in advance
Manos
 
Manos,

Does it give you what you want if you make a Query based on your table,
and in the Field row of a blank column in the query design grid, put this...
TheAverage: [Games]/[Number of Balls]
 
Back
Top