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 174212Now 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.
Hi All, Did anyone get the chance to look into the above post.
Thanks a lot for your help in advance.
Hi All, Did anyone get the chance to look into the above post.
Thanks a lot for your help in advance.
Hi All, Did anyone get the chance to look into the above post.
Thanks a lot for your help in advance.
You might want to try posting in the Database or Programming Forums, you may get a better result.