Please help - urgent

I have the following table where carrier field is empty
Ost Ocity Dstate Dcity Region Carrier
A B C Dcity MW
E F G H East
I J K L South
M N O P MW
Q R S T East

I need to create a query which should ask the user to enter the
following info


carrier for MW region
Carrier for East region
Carrier for South region


Based on answers inputted by the user, the carrier field has to be
populated.


The following condition needs to be satisfied-
the carrier field will have to be same if it has same region.


Example if the user enters the following info


carrier for MW region Sai
Carrier for East region Mai
Carrier for South region yoi

Then

Final table will look like this


Ost Ocity Dstate Dcity Region Carrier
A B C Dcity MW sai
E F G H East mai
I J K L South yoi
M N O P MW sai
Q R S T East mai


can you help with the query or evern a Form? which ever will be
easier
and effective?

thanks

Is this a one-time activity that you need to do? If yes, you could use an
update query like this:

UPDATE TableName
SET Carrier =
Switch(Region="MW", [Enter Carrier for MW Region:],
Region="East", [Enter Carrier for East Region:],
Region="South", [Enter Carrier for South Region:]);

--

Ken Snell
MS ACCESS MVP


"subs" wrote in message
...
I have the following table where carrier field is empty
Ost Ocity Dstate Dcity Region Carrier
A B C Dcity MW
E F G H East
I J K L South
M N O P MW
Q R S T East

I need to create a query which should ask the user to enter the
following info


carrier for MW region
Carrier for East region
Carrier for South region


Based on answers inputted by the user, the carrier field has to be
populated.


The following condition needs to be satisfied-
the carrier field will have to be same if it has same region.


Example if the user enters the following info


carrier for MW region Sai
Carrier for East region Mai
Carrier for South region yoi

Then

Final table will look like this


Ost Ocity Dstate Dcity Region Carrier
A B C Dcity MW sai
E F G H East mai
I J K L South yoi
M N O P MW sai
Q R S T East mai


can you help with the query or evern a Form? which ever will be
easier
and effective?

thanks

On Apr 13, 6:20*pm, "Ken Snell \(MVP\)"
wrote:
Is this a one-time activity that you need to do? If yes, you could use an
update query like this:

UPDATE TableName
SET Carrier =
Switch(Region="MW", [Enter Carrier for MW Region:],
Region="East", [Enter Carrier for East Region:],
Region="South", [Enter Carrier for South Region:]);

--

* * * * Ken Snell
MS ACCESS MVP

"subs" wrote in message

...



I have the following table where carrier field is empty
Ost * * Ocity * Dstate *Dcity * Region *Carrier
A * * * B * * * C * * * Dcity * MW
E * * * F * * * G * * * H * * * East
I * * * J * * * K * * * L * * * South
M * * * N * * * O * * * P * * * MW
Q * * * R * * * S * * * T * * * East

I need to create a query which should ask the user to enter the
following info

carrier for MW region
Carrier for East region
Carrier for South region

Based on answers inputted by the user, the carrier field has to be
populated.

The following condition needs to be satisfied-
the carrier field will have to be same if it has same region.

Example if the user enters the following info

carrier for MW region * * * * * * * Sai
Carrier for East region * * * * * * Mai
Carrier for South region * * * * * yoi

Then

Final table will look like this

Ost * * Ocity * Dstate *Dcity * Region *Carrier
A * * * B * * * C * * * Dcity * MW * * *sai
E * * * F * * * G * * * H * * * East * *mai
I * * * J * * * K * * * L * * * South * yoi
M * * * N * * * O * * * P * * * MW * * *sai
Q * * * R * * * S * * * T * * * East * *mai

can you help with the query or evern a Form? which ever will be
easie
and effective?

thanks- Hide quoted text -

- Show quoted text -

thanks but the user might update the carrier field many times. Is
there a form or some other way this can be solved? thanks

You can create a form that has a separate textbox for each of the carrier
types, then put a command button on the form that will run a stored query
similar to this:

UPDATE TableName
SET Carrier =
Switch(Region="MW", Forms![NameOfYourForm]![NameOfMWTextbox],
Region="East", Forms![NameOfYourForm]![NameOfEastTextbox],
Region="South", Forms![NameOfYourForm]![NameOfSouthTextbox]);

--

Ken Snell
MS ACCESS MVP



"subs" wrote in message
...
On Apr 13, 6:20 pm, "Ken Snell \(MVP\)"
wrote:
Is this a one-time activity that you need to do? If yes, you could use an
update query like this:

UPDATE TableName
SET Carrier =
Switch(Region="MW", [Enter Carrier for MW Region:],
Region="East", [Enter Carrier for East Region:],
Region="South", [Enter Carrier for South Region:]);

--

Ken Snell
MS ACCESS MVP

"subs" wrote in message

...



I have the following table where carrier field is empty
Ost Ocity Dstate Dcity Region Carrier
A B C Dcity MW
E F G H East
I J K L South
M N O P MW
Q R S T East

I need to create a query which should ask the user to enter the
following info

carrier for MW region
Carrier for East region
Carrier for South region

Based on answers inputted by the user, the carrier field has to be
populated.

The following condition needs to be satisfied-
the carrier field will have to be same if it has same region.

Example if the user enters the following info

carrier for MW region Sai
Carrier for East region Mai
Carrier for South region yoi

Then

Final table will look like this

Ost Ocity Dstate Dcity Region Carrier
A B C Dcity MW sai
E F G H East mai
I J K L South yoi
M N O P MW sai
Q R S T East mai

can you help with the query or evern a Form? which ever will be
easie
and effective?

thanks- Hide quoted text -

- Show quoted text -

thanks but the user might update the carrier field many times. Is
there a form or some other way this can be solved? thanks