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] How to calculate minutes between two dates/times
• › Excel-find difference between 2 letters
• › Finding the time between two different times in excel issue
• › [Solved] Delete rows between two lines using a macro
• › [Solved] Excel - Need To Calculate Days And Hours Between Two Dates
• › [Solved] How to calculate no of days between two dates in Ms.Excel ?.
• › Macro to add a column in between two columns