DAVG between dates

[MikeDuffield]

Hi everyone,

I'm using DAVG to look up average days in a query. All works fine but I'd like additional functionality. Here's what I have so far:

=DAvg("[kitted2completed]","KittedComp")

What I would like is the above to return an average based on dates from and to in column "Comp".

For instance, I might want only data with a value between now() and 14 days ago. (ie jobs completed in the last two weeks)

Is this easy to do?

I've found examples elsewhere that help me specify and exact value, but not between values.


Cheers in advance!
Mike.

 

[MikeDuffield]

When I think about it more, is it best to make a query to filter dates first, then use DAVG to look up averages in the filtered data?

 

[MikeDuffield]

Can anyone offer any input on this please?

I think there's a few ways to achieve what I want, but I'd like the most efficient / best practice really...

Thanks in advance.