Help calculating value based on field when primary key allows duplicates?

[JimmD43]

I need to have my form calculate the average value of a field that is present on a form where duplicates for the primary key are allowed. For the sake of simplicity, I am using the example below with the table tblTravel and the form frmTravel.

Primary Key: ID#


Field: Miles

ID#: 4465 Miles: 10
ID#: 4465 Miles: 20
ID#: 2310 Miles: 50
ID#: 2310 Miles: 70

I need to be able to calculate the average of 10 and 20 to get 15 and the average of 50 and 70 to get 60. Can anyone help?

[pbaldy]

Options include a Totals query using Avg, a recordset using a similar query, or DAvg(), depending on your specific needs.

[JimmD43]

Options include a Totals query using Avg, a recordset using a similar query, or DAvg(), depending on your specific needs.

DAvg() was exactly what I needed. Thank you so much!

[pbaldy]

Happy to help!