Average length of days for a contract at several locations.

[Ikkyu]

Hi all, I have a query that finds a location in one table and a start and end date for a contract in another table, many contract start and end dates for each location. I am trying to search by location and find the average length of the contracts at that location(avg length in days.)

Every time I try I end up with a wrong answer. I'm doing this in design view and checking it by hand on paper.


The criteria is like[enter loctation..... then I try to find the difference in start and end dates the in a new column avg that.

I'm clueless.

Thanks for any help.

 

[Ikkyu]

Re: Solved: Average length of days for a contract at several locations.

I've got the average now. I can search by location and get the avg day by using one query to subtract the dates then a query using the firs query to get the avg. Now I can't round the days to one decimal. I set the decimal to 1 in properties for the avg field. Does anyone know what I am doing wrong?


Edit: I change the format from general number to fixed.