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.