One More Time (Repost)

[Guest]

OK I have two tables. I want to get the average flow rate for the calendar
month from each table. I've been able to get it, but only for one month at a
time. I want to be able to track that, because I have a report that needs to
run at the end of the month, I have to add the average from stripper1 to the
average from stripper 2 to get the totoal average flow through each stripper.
Every day a guy takes a reading of the flows. He then sends me that
information, I put it into the tables.

So I have something like this:

Air Stripper 1 Air
Stripper 2
Date Stripper Flow Rate Date
Stripper Flow Rate
1/1 500 1/1
550
1/2 545 1/2
520
1/3 515 1/3
575

Now I have a query that takes the average of both Flow Rate Columns, I have
to enter the date parameters manually, and that is what I need to avoid.

Is there a way to build a query that will look at everyday for a month and
give me the average flow?

 

[Guest]

OK never mind I got it!

 

[Joseph Meehan]

OK I have two tables. I want to get the average flow rate for the
calendar month from each table. I've been able to get it, but only
for one month at a time. I want to be able to track that, because I
have a report that needs to run at the end of the month, I have to
add the average from stripper1 to the average from stripper 2 to get
the totoal average flow through each stripper. Every day a guy takes
a reading of the flows. He then sends me that information, I put it
into the tables.

So I have something like this:

Air Stripper 1 Air
Stripper 2
Date Stripper Flow Rate Date
Stripper Flow Rate
1/1 500 1/1
550
1/2 545 1/2
520
1/3 515 1/3
575

Now I have a query that takes the average of both Flow Rate Columns,
I have to enter the date parameters manually, and that is what I need
to avoid.

Is there a way to build a query that will look at everyday for a
month and give me the average flow?

Maybe you should allow a little more time for your answers. Three post
in three hours is a lot. Allow some time for people to read and respond.
Remember this is a user to user system.

 

[Ron2005]

Take that same sum/averaging query you have.

create a copy and

Change input request for criteria to be "between [Enter Starting Date]
and [Enter Ending Date]

For safety sake and to increase usability of query:
Add a field that is year([capture date]) and group on that
Add a field that is Month([capture date]) and group on that
Add a field that is day([capture date]) and group on that

Add them in that sequence and also sort on those fields.

That should give you what you want.
This will definitely work for a single month, and most probably for
larger date ranges.