Update Query?

[mistic32809]

Hello,

I am attempting to create a query that looks at two tables and what I want
that query to do is to update some fields on a table that looks at another
field on the other table. So far this is what I have and it's not working....

Field: Field Type
Table: PRAD Fills-Current Week
Updated to: External
Criteria: [Xref: Hire Type]![Filled Type]
or: "Convert Non-Employee to Employee"
"Rehire"
"Hire"
"Concurrent Hire"

 

[Jeff Boyce]

Please post the SQL statement of your query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[mistic32809]

Sorry Jeff but if I didn't already include that on my first inquiry then I'm
not sure what you are talking about when you refer to the query SQL statement.

Please post the SQL statement of your query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hello,

I am attempting to create a query that looks at two tables and what I want
that query to do is to update some fields on a table that looks at another
field on the other table. So far this is what I have and it's not
working....

Field: Field Type
Table: PRAD Fills-Current Week
Updated to: External
Criteria: [Xref: Hire Type]![Filled Type]
or: "Convert Non-Employee to Employee"
"Rehire"
"Hire"
"Concurrent Hire"

 

[KARL DEWEY]

Open the query in design view. Next go to View, SQL View and copy and past it
here.

--
KARL DEWEY
Build a little - Test a little

Sorry Jeff but if I didn't already include that on my first inquiry then I'm
not sure what you are talking about when you refer to the query SQL statement.

Please post the SQL statement of your query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hello,

I am attempting to create a query that looks at two tables and what I want
that query to do is to update some fields on a table that looks at another
field on the other table. So far this is what I have and it's not
working....

Field: Field Type
Table: PRAD Fills-Current Week
Updated to: External
Criteria: [Xref: Hire Type]![Filled Type]
or: "Convert Non-Employee to Employee"
"Rehire"
"Hire"
"Concurrent Hire"

 

[mistic32809]

UPDATE [Xref: Hire Type] INNER JOIN [PRAD Fills - Current Week] ON [Xref:
Hire Type].[Filled Type] = [PRAD Fills - Current Week].[Filled Type] SET
[PRAD Fills - Current Week].[Filled Type] = "External"
WHERE ((([PRAD Fills - Current Week].[Filled Type])=[Xref: Hire
Type]![Filled Type])) OR ((([PRAD Fills - Current Week].[Filled
Type])="Rehire")) OR ((([PRAD Fills - Current Week].[Filled Type])="Hire"))
OR ((([PRAD Fills - Current Week].[Filled Type])="Concurrent Hire")) OR
((([PRAD Fills - Current Week].[Filled Type])="External")) OR ((([PRAD Fills
- Current Week].[Filled Type])="Convert Non-Employee to Employee"));

Open the query in design view. Next go to View, SQL View and copy and past it
here.

--
KARL DEWEY
Build a little - Test a little

Sorry Jeff but if I didn't already include that on my first inquiry then I'm
not sure what you are talking about when you refer to the query SQL statement.

Please post the SQL statement of your query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hello,

I am attempting to create a query that looks at two tables and what I want
that query to do is to update some fields on a table that looks at another
field on the other table. So far this is what I have and it's not
working....

Field: Field Type
Table: PRAD Fills-Current Week
Updated to: External
Criteria: [Xref: Hire Type]![Filled Type]
or: "Convert Non-Employee to Employee"
"Rehire"
"Hire"
"Concurrent Hire"

 

[KARL DEWEY]

First you only want records that match in these two fields --
[Xref: Hire Type].[Filled Type] = [PRAD Fills - Current Week].[Filled Type]

That requirement is repeated --
WHERE
((([PRAD Fills - Current Week].[Filled Type])=[Xref: Hire Type]![Filled
Type]))

So this does not matter ---
OR ((([PRAD Fills - Current Week].[Filled Type])="Rehire"))
OR ((([PRAD Fills - Current Week].[Filled Type])="Hire"))
OR ((([PRAD Fills - Current Week].[Filled Type])="Concurrent Hire"))
OR ((([PRAD Fills - Current Week].[Filled Type])="External"))
OR ((([PRAD Fills - Current Week].[Filled Type])="Convert Non-Employee to
Employee"));

Maybe your requirement could be understood if you restate it.

--
KARL DEWEY
Build a little - Test a little

UPDATE [Xref: Hire Type] INNER JOIN [PRAD Fills - Current Week] ON [Xref:
Hire Type].[Filled Type] = [PRAD Fills - Current Week].[Filled Type] SET
[PRAD Fills - Current Week].[Filled Type] = "External"
WHERE ((([PRAD Fills - Current Week].[Filled Type])=[Xref: Hire
Type]![Filled Type])) OR ((([PRAD Fills - Current Week].[Filled
Type])="Rehire")) OR ((([PRAD Fills - Current Week].[Filled Type])="Hire"))
OR ((([PRAD Fills - Current Week].[Filled Type])="Concurrent Hire")) OR
((([PRAD Fills - Current Week].[Filled Type])="External")) OR ((([PRAD Fills
- Current Week].[Filled Type])="Convert Non-Employee to Employee"));

Open the query in design view. Next go to View, SQL View and copy and past it
here.

--
KARL DEWEY
Build a little - Test a little

Sorry Jeff but if I didn't already include that on my first inquiry then I'm
not sure what you are talking about when you refer to the query SQL statement.

:

Please post the SQL statement of your query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hello,

I am attempting to create a query that looks at two tables and what I want
that query to do is to update some fields on a table that looks at another
field on the other table. So far this is what I have and it's not
working....

Field: Field Type
Table: PRAD Fills-Current Week
Updated to: External
Criteria: [Xref: Hire Type]![Filled Type]
or: "Convert Non-Employee to Employee"
"Rehire"
"Hire"
"Concurrent Hire"