Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mmischke
Starting Member
2 Posts |
 Posted - 2008-09-10 : 12:25:25
|
| I am receiving run time error 3001; Invalid Argument for the following Code:strSQL = "INSERT INTO [Max UMI for Reference1] ( Reference1, MaxOfUMI )"strSQL = strSQL & " SELECT [F1 Raw Data for Rolling Period].Reference1, Max([F1 Raw Data for Rolling Period].UMI) AS MaxOfUMI"strSQL = strSQL & " FROM [F1 Raw Data for Rolling Period]"strSQL = strSQL & " WHERE (([F1 Raw Data for Rolling Period].ReceiverProv)<>'CA/Not assigned')"strSQL = strSQL & " GROUP BY [F1 Raw Data for Rolling Period].Reference1;"CurrentDb.Execute (strSQL)strSQL has been created as a string. Each time the code is run I get the error. Anyone have any ideas on this? In desparation..... |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2008-09-11 : 05:11:54
|
| can you print out the contents of "strSQL"any chance of a mismatch between the data types of the SELECT query and the table? |
 |
|
|
|
|
|
Invalid Argument in "INSERT INTO"