Search results

The problem turned out to be some form of corruption. I know that string and date are reserved words. This was just for an example as I couldn't actually post my original database up here. Thanks for all the replies!

It is good to be here! Thanks! I'm leaning towards something being corrupted myself! I was handed this Access nightmare and am trying to clean it up. I did already copy and paste the query into a new query but that didn't fix the problem. I am using Access 2007, but I believe this DB was...

Firstly, I have minimal previous experience with Access but year of experience with SQL, databases and the like (former Informix DBA and Unix Sys Admin). I have an INSERT query that I use to grab data from a table and concatenate it together to create a specific string and store that string...