Micron,
How would your solution look with my DoCmd.RunSQL statement ? See statement below . . .
strCompany = strQuote & [strCompany] & strQuote
DoCmd.RunSQL "Insert Into [Sales Tax Table] ([Company Name], Grocery_Amount, Amount, Grocery_Date, Category) Values ('" & [strCompany] & "', '" & [strGroAmount] & "', '" & [strAmount] & "', '" & [strToday_Date] & "', '" & [strCaregory_Name] & "')"
I gave an example in post 31. Did I use the wrong field or the wrong sql? I'm not sure which is the field(s) that may contain '. Is it only strCompany?
EDIT - these are really field names - [strSomething]?? I'm not understanding why you have [strCompany] as well as strCompany. Your amount and date fields are text?
Last edited: