Search results

I'm working on the following SQL for a query: SELECT PERSON_NAME.Person_id, PERSON_NAME.delete, PERSON_NAME.Lastname_name_local1, PERSON_NAME.Person_name_id, PERSON_NAME.Middle_name, PERSON_NAME.Name_suffix FROM PERSON_NAME WHERE (((PERSON_NAME.person_id) In (SELECT [person_id] FROM...

I'm working on the following SQL for a query: SELECT PERSON_NAME.Person_id, PERSON_NAME.delete, PERSON_NAME.Lastname_name_local1, PERSON_NAME.Person_name_id, PERSON_NAME.Middle_name, PERSON_NAME.Name_suffix FROM PERSON_NAME WHERE (((PERSON_NAME.person_id) In (SELECT [person_id] FROM...

I'm working on the following SQL for a query: SELECT PERSON_NAME.Person_id, PERSON_NAME.delete, PERSON_NAME.Lastname_name_local1, PERSON_NAME.Person_name_id, PERSON_NAME.Middle_name, PERSON_NAME.Name_suffix FROM PERSON_NAME WHERE (((PERSON_NAME.person_id) In (SELECT [person_id] FROM...

The meat and potatoes of the problem INSERT INTO [new attempt] ( Last_name, First_name, Pt_id1, Pt_id2, SSN, Dob, Stated_Age, Current_Sex, Race_ind, [Home Address], City_name, State_cd, [Zip Code], Lab_name, Old_Form_id, [Facility Address], [Facillity Address 2], City, State, [Facility Zip]...

I tried different syntaxes and tried the FROM MY TABLE; at the end, still not workin

here is the code I put in: Expr5: ([select left([Facility_Phone],3) & '-' & Mid([Facility_Phone],4,3) & '-' & Right([Facility_Phone],4) but its not working. I need to pull the first three area code, insert dash, next three, insert dash, then final four. I put this expression in my APPEND...

Ok Friends here's my new problem: I have an access Table in which I have phone numbers without dashes in a particular field. I need to export this Table into a fixed width text file WITH dashes in the phone number. The problem is I when I put a input mask for dashes on the table, in design...

That did the job.. Thanks a million guys I appreciate you helping me

I'm a currently working on an access database in which i've run a series of APPEND queries to populate a NEW TABLE Ive created. What I need to do is populate the RACE field in this new table with data based on 5 different RACE fields from another table entitled PERSON. So what I have is a...