Search results

Thanks for you help again, I am a newbie at this. This is what it is genreating qryLast3MonthlyAvgMonthAverage $ ReceivedAugust 2009$26,578,370.37November 2009$57,661,802.05October 2009$70,473,856.75September 2009$67,832,311.22 and the SQL behind the query i am using, I changed the group by...

Thanks but I'm still getting August, Sept, Oct and Nov. How would i get the current month plus the last two?

I have a query that is generating a daily average received in $ per month, but when i use the ">=DateAdd("m",-3,Date())" for the criteria it is pulling the last 90 days. Here is the SQL for the query; SELECT Format([Bank_Statement_Summary].[GL_Date],"mmmm-yyyy") AS [Month]...

After play with it a little yesterday i now have a runtime error '3044' not a valid path. i have verified the location of the file and it is correct, could be that it is on a server and not my C: drive? here is the code. DoCmd.TransferText , acImportDelim, "Contracts"...

Thank-you but now i am getting a Run-time error '31519' You cannot import this file.

i am trying to import a CSV file into a table based on the selected date but i am getting a run-time error '2495' The action or method requires a Table Name argument. Here is my code if anyone can help. DoCmd.TransferText , acImportDelim, Contracts...

I am new to learning code but i am learning quickly. I am trying to insert code in Access that the user will first select the date they want then the code will open excel (not visiable) and format the file from a csv file to a xls file but i am missing something and i am getting a runtime error...