Search results

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]...

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...