Recent content by sross

UPDATE [2013-P3 Data] SET WORKING_ADDL1 = ADDRL1 This is what I have (thanks had a spelling mistake). It looks like it's working in the query but why can't I see it in the main file? How do I do that?

It asks me for a parameter value for Working_Addrl1 - what should I enter here? And the file name is not file - it ends up in [] when I do the query. Should I remove these? Thanks again.

I was trying it in sql but it isn't working... Update file Set working_addrl1 = addrl1 Thanks! :)

I am trying to run a simple update query to copy data from one column (Addrl1)to another column (Working_Addrl1) within the same file and I can't for the life of me figure it out. Then I need to repeat for addrl2 and addrl3 to working_addrl2 and working_addrl3. Any help would be greatly...

I am trying to check for duplicates in a mailing list. I need to see these fields fstnm, lstnm, spfstnm, splstnm, add1, zip where fstnm=spfstnm, lstnm=splstnm. Sorry if I am not as clear as you need me to be - I am totally new to this. Thx

I am trying to create a query with the following criteria and have no clue where to start. fstnm=spname, lstnm=splstnm, add1, zip

Help! I am trying to manipulate a find duplicates query using the following criteria: Fstnm L2, Lstnm L5, Add1, Zip - can't figure out what I am not doing. This is what I have done so far: SELECT [Duplicate Identification Dataset].[FSTNM], [Duplicate Identification Dataset].[LSTNM]...