How do I use functions to update queries in Access?

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

Guest

For example, I would like access to calculate the average of 3 fields. When
I attempt to use the avg function, Access returns errors, such as conversion
failure. Any suggestions would be helpful.
 
A Conversion failure probably happens against a Null value. Use Nz().

Nz(cint(somefield),0)
 
I think the Frustrated Student has "committed spreadsheet" and is attempting
to perform an Excel-like average across 3 fields rather than across three
records. I could be wrong so maybe Frustrated could provide some sample
records and the desired "average" calculated. It would be helpfull to know
if any of the values might be Null.
 
Back
Top