Search results

Hi Bob, Here is the SQL. What I want to do is be able to go in and update various fields in the enrollments table - but update it within the query. Thanks in advance SELECT [3_Enrollments].[Employee ID], [3_Enrollments].[Participant Name], [Company Roster].NAME, [1_Program List].[Course...

I have created a query which is based on 2 tables. I now want to use the query to update content as needed in one of the tables When I try to do this it says, Operation must use an updateable query I used the update feature but it still says must be created in updateable query I am at a...

No brackets win!!!! THANK YOU ALL!!!!!!! SELECT [EMPLID], [NAME], [JOBTITLE], [ML_LOC_CITY], [ML_DEPT_G_DESCR], [GRADE], [ML_REPORTS_TO_NAME], [ML_DEPT_E_DESCR], [ML_EMAILID], [EMPL_STATUS], [ML_DEPT_F_DESCR], [ML_DEPT_H_DESCR], [HIRE_DT] FROM Roster UNION SELECT [EMPLID], [NAME], [JOBTITLE]...

technically that skips the field - however when I hit run it still looks for a parameter value. I have a feeling I can't do what I need on this one. SELECT [EMPLID], [NAME], [JOBTITLE], [ML_LOC_CITY], [ML_DEPT_G_DESCR], [GRADE], [ML_REPORTS_TO_NAME], [ML_DEPT_E_DESCR], [ML_EMAILID]...

thanks. do you know if there is a way to add a null value for the fourth field of table 2? Basically when I run the union anything in table 2 will not have a value in field 4. I am not sure if I am explaining this correctly so sorry in advance.

I am not an expert user of Access. I am trying to Union two Tables but I am looking to pull columns from one table that is not part of table 2. Is there a way to do this. Table 1 Field 1 Field 2 Field 3 Field 4 data data data data data data data data data data data data Table 2 Field 1 Field 2...