query function question

[Daryl2106]

Hi,



I have four fields containing values returned by a query. I want to add a field to the query that will calculated the average which I can then include in a form and report. When I build I get an error. I'm only learning VBA and SQL and I have exhausted all the possible simple solutions...also, I have been reading some posts that suggest adding to the SQL. How does one know where to add to the SQl statement(s)?? (I know this is probably a stupid question)


Thanks!

[June7]

There is no built-in function to average fields. If each field will ALWAYS have data, a simple expression will do:

Average: (field1 + field2 + field3 + field4) / 4

If any field could be null, then this gets complicated.

With Access 2010 you can do the calculation in a Calculated field type of the table.

Access Help has info on building queries that include creating fields with expression.