I have a database with 3 fields. The first is a date field. Fields B and C are numeric. I enter a value in field B every day. I enter a value in field C every 6 days. When I Group Up by month, for example, and then average the summary records, field B is OK; but field C is about 1/6th the correct value. How can I average only the records which are not empty?