How do I use functions to update queries in Access?

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.
 
M

[MVP] S.Clark

A Conversion failure probably happens against a Null value. Use Nz().

Nz(cint(somefield),0)
 
D

Duane Hookom

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prior 3 Mo Avg Function 1
Use In() Expression as Query criteria with guts from Function 1
Ave function 2
Access/Excel discrepancy 3
Calculate an Average of row entry fields 13
Using Avg on results of four seperate queries 2
Calculating Avg with null values 14
Querying mean values without using "Totals" 6

Top