Search results

I took your advice and changed around the GROUP BY and HAVING functions. The SQL str will now create a QRY, but it doesn't seem to be grouping by the str_recr only mon1, mon2, mon3. What am I missing in the GroupBy statement? strSQLc = "SELECT [tbl Officer Prospecting Applicant...

I have been trying to get this SQL string statement to run for some time now. The current error is: You tried to execute a query that does not include the specified expression 'Recruiter' as part of an aggregate function. (Error 3122) I am assuming this is due to the code thinking 'recruiter'...

Yes the spreadsheet is a tool used to see if sales leads are qualified, so the spreadsheets will be used by multiple people from different computers. I would like to upload all those individual spreadsheets without manual data entry into the master database.

They pathname of the file and info in the .xls will change everytime, so I dont think I can link the spreadsheet without the file picker?

I am trying to choose an excel file with file picker. Then insert a recordset into an already existing table in Access from the Excel file. The first Column in Excel has the Field Names of the access table and the second row has the information. The below code is what I have so far, I am...