update query not working

[Guest]

UPDATE [Policy Infomation] INNER JOIN [Working Table] ON ([Policy
Infomation].TypeOfHaul = [Working Table].TypeOfHaul) AND ([Policy
Infomation].TypeOfPolicy = [Working Table].TypeOfPolicy) SET [Working
Table].Carrier = [Policy Information].Carrier;


I know the fields are equal in both tables...Anyone know why this query is
not working?

 

[Gary Walter]

UPDATE [Policy Infomation] INNER JOIN [Working Table] ON ([Policy
Infomation].TypeOfHaul = [Working Table].TypeOfHaul) AND ([Policy
Infomation].TypeOfPolicy = [Working Table].TypeOfPolicy) SET [Working
Table].Carrier = [Policy Information].Carrier;


I know the fields are equal in both tables...Anyone know why this query is
not working?
--

I believe the first table after UPDATE implies the table
that will be updated. You might try reversing order...

UPDATE
[Working Table]
INNER JOIN
[Policy Infomation]
ON
([Working Table].TypeOfHaul=[Policy Infomation].TypeOfHaul )
AND
([Working Table].TypeOfPolicy=[Policy Infomation].TypeOfPolicy )
SET [Working Table].Carrier = [Policy Information].Carrier;

 

[Guest]

Gary,

I tried it switched around and I still get the dialog asking me to enter
parameter value"
Policy Information.Carrier

This same query was working yesterday and I don't know what happen to cause
it stop now.
--
Leslie

UPDATE [Policy Infomation] INNER JOIN [Working Table] ON ([Policy
Infomation].TypeOfHaul = [Working Table].TypeOfHaul) AND ([Policy
Infomation].TypeOfPolicy = [Working Table].TypeOfPolicy) SET [Working
Table].Carrier = [Policy Information].Carrier;


I know the fields are equal in both tables...Anyone know why this query is
not working?
--

I believe the first table after UPDATE implies the table
that will be updated. You might try reversing order...

UPDATE
[Working Table]
INNER JOIN
[Policy Infomation]
ON
([Working Table].TypeOfHaul=[Policy Infomation].TypeOfHaul )
AND
([Working Table].TypeOfPolicy=[Policy Infomation].TypeOfPolicy )
SET [Working Table].Carrier = [Policy Information].Carrier;

 

[Gary Walter]

Open up table [Policy Information] in Design View
and find out what happened to spelling of this field
(hopefully it still exists).

I tried it switched around and I still get the dialog asking me to enter
parameter value"
Policy Information.Carrier

This same query was working yesterday and I don't know what happen to
cause
it stop now.
--
Leslie

UPDATE [Policy Infomation] INNER JOIN [Working Table] ON ([Policy
Infomation].TypeOfHaul = [Working Table].TypeOfHaul) AND ([Policy
Infomation].TypeOfPolicy = [Working Table].TypeOfPolicy) SET [Working
Table].Carrier = [Policy Information].Carrier;


I know the fields are equal in both tables...Anyone know why this query
is
not working?
--

I believe the first table after UPDATE implies the table
that will be updated. You might try reversing order...

UPDATE
[Working Table]
INNER JOIN
[Policy Infomation]
ON
([Working Table].TypeOfHaul=[Policy Infomation].TypeOfHaul )
AND
([Working Table].TypeOfPolicy=[Policy Infomation].TypeOfPolicy )
SET [Working Table].Carrier = [Policy Information].Carrier;

 

[Guest]

Gary, thanks for your help. I have looked until my eyes hurt. You are
correct, Information was missing the "r". Thought I was going insane on
something so simple.

Again...thanks alot.

--
Leslie

Open up table [Policy Information] in Design View
and find out what happened to spelling of this field
(hopefully it still exists).

I tried it switched around and I still get the dialog asking me to enter
parameter value"
Policy Information.Carrier

This same query was working yesterday and I don't know what happen to
cause
it stop now.
--
Leslie

:
UPDATE [Policy Infomation] INNER JOIN [Working Table] ON ([Policy
Infomation].TypeOfHaul = [Working Table].TypeOfHaul) AND ([Policy
Infomation].TypeOfPolicy = [Working Table].TypeOfPolicy) SET [Working
Table].Carrier = [Policy Information].Carrier;


I know the fields are equal in both tables...Anyone know why this query
is
not working?
--
I believe the first table after UPDATE implies the table
that will be updated. You might try reversing order...

UPDATE
[Working Table]
INNER JOIN
[Policy Infomation]
ON
([Working Table].TypeOfHaul=[Policy Infomation].TypeOfHaul )
AND
([Working Table].TypeOfPolicy=[Policy Infomation].TypeOfPolicy )
SET [Working Table].Carrier = [Policy Information].Carrier;