Access query to find avg between two dates

December 2, 2010 at 19:27:39
Specs: Windows XP
Hi All,

I want to come up with a query in MS Access which will find the average between two dates. Below is the data sample which I have :

L1 L2 Retx Prd As of Date Amt
ABC XYZ AFX XXF 11/29/2010 112123
IFA SDF BBS STR 11/28/2010 112841
SFS FDS KBS SDF 11/27/2010 154422
SLS SDR KSS SLF 11/26/2010 164222
RES QSS REA ASE 11/25/2010 174212

Now I have the above data in one of my access database table. I want to come up with an average of Amt between two dates .i.e. As of Date 11/25/2010 to 11/29/2010 and I want the query in such a way that it will ask for the user input for entering the dates. .i.e. From Date to To Date.
i.e. a input box should reflect on the screen when the user will run the query.

Thanks a lot for your help in advance.


See More: Access query to find avg between two dates

Report •


#1
December 4, 2010 at 01:02:11
Hi All,

Did anyone get the chance to look into the above post.

Thanks a lot for your help in advance.


Report •

#2
December 4, 2010 at 02:26:41
Hi All,

Did anyone get the chance to look into the above post.

Thanks a lot for your help in advance.


Report •

#3
December 8, 2010 at 05:06:22
Hi All,

Did anyone get the chance to look into the above post.

Thanks a lot for your help in advance.


Report •

Related Solutions

#4
December 8, 2010 at 07:40:17
You might want to try posting in the Database or Programming Forums, you may get a better result.

MIKE

http://www.skeptic.com/


Report •


Ask Question