Recent content by mclifford82

I've always found w3schools to be a good introduction to SQL. http://www.w3schools.com/sql/default.asp

Actually, upon further reflection, I came to wonder if a View would work either, as those are non-updateable (that I know of). My supervisor is going to change the Oracle table structure to remove the ampersand, so we're going to solve it that way. Still, I find it odd that Access allows...

Here is an example that illustrates the dilemma. I have tried each of your suggestions, inlcuding [Tablename].[Fieldname] for both Field and AppendTo, as well as bracketing the names. I've even made the edits in SQL view. When you open the query, you'll note that field a&b shows in the...

I'll have to post back with the full query tomorrow, as it's at work and I don't have access to it at the moment. I'll also retry the brackets, though I am fairly certain I did try that. Append Query: Field: RT&T AppendTo: [RT&T] No aggregation, just a straight-up append from one source to...

Hello everyone, I have a query that I am using as a source to append data into a linked Oracle table. One of the field names in the destination table is RT&T, but whenever I close the query window, it changes the table name to RT & T, and the query no longer works. If I run the query from...