form with condition needed

S

subs

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


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


please note that regions are based on Destination states. Based on
the
answers inputted by the user, the carrier field has to be populated.

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


Example


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


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?




Reply Reply to author Forward
 
Top