i have the dcount working for a field. now i need to take the dcount and divide this by the average that i have calculate for this field. how do i write this? my dcount answer is 4 and my average count is 2 so therefore the answer i am looking for is 2. i did the =(4/2) and i get the answer but when i pull the same information for a different date, the answers are not correct. don't i have to write this out in someway??? such as
=[fieldname]/[avg]
=[fieldname]/[avg]