Search results

I sure am! Lived here for about 5 years now :) You know, I clicked on view SQL and it really didn't look right so I thought I was in the wrong spot. I will remember that the next time I have a questions and include it in my initial post. Sounds like it works out better if you can view the...

Well darn, I had to scratch this whole project and start over. It seems that there were more problems than solutions! I have the disadvantage of not knowing a whole lot about Access. I don't know how to post the SQL of the query... I was using experssion builder in the query design. Thank you...

Good Morning... back at it again :eek: I questioned this myself. I am very new in Access and find that most of these terms don't really strike me as common sense. I couldn't find a good description of a string, although I did find that it is used a lot. Basically, the SSN field represents...

Hello pbaldy, I put in exactly what you have (w/my field name of course) and this is the error I have been getting: "Syntax error (comma) in query expression 'TIMEK_PERSONS.[Left([SSN],4)]" I am running Access 2003 w/Win XP Pro (Ver. 2002) operating system. My field consists of a social...

I have seen variations of this question and have tried to modify for my purpose, but have been unsuccessful. I need to extract the first four digits of the Social Security Number. We no longer view the whole number, but a variation of the first four of social and first four of first name. I have...