Access query to find avg between two dates

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.

• › [Solved] Need EXCEL formula to find an average of days hours minutes
• › [Solved] Excel - Need to help hour between the dates
• › [Solved] Hello, I would like to find a way to search multiple entry.
• › [Solved] Macro to find text string in multiple Excel docs
• › Showing the difference between two large datasets
• › [Solved] Excel Macro - Find & Replace - Open options automatically
• › [Solved] Time Elapsed in hours between multiple dates in excel