Query or a form required

[subs]

I have the following table where carrier field is empty

Ost Ocity Dstate Region
Dcity Carrier
A B IL MW Chicago
C D MA East Boston
E F IN MW Indianpolis
G H AR South fayetteville


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.
So the carrier field will 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 Region
Dcity Carrier
A B IL MW
Chicago Sai
C D MA East
Boston Mai
E F IN MW
Indianpolis Sai
G H AR South
fayetteville Yoi

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

 

[Duane Hookom]

If the carriers are always paired with the specific region, then I wouldn't
update a column/field in the table. Just create a table of the Regions and
Carriers. You can then use this table in a query where you need to see the
carrier.

 

[subs]

If the carriers are always paired with the specific region, then I wouldn't
update a column/field in the table. Just create a table of the Regions and
Carriers. You can then use this table in a query where you need to see the
carrier.
--
Duane Hookom
Microsoft Access MVP












- Show quoted text -

Duanne

but question is how would i update the table of carriers and regions
every time the user uses this table
because

region carrier
midwest
east
south
west
midwest
south

carrier for every region changes every time the user uses this table.
It is not the same. is there a parameter query or a form that he
could use? yr help would be appreciated

 

[Duane Hookom]

I would have the user update a lookup table and then run and update query
based on the lookup table and your other table. Join the region fields and
update the carrier field based on the value in the lookup table.

 

[subs]

I would have the user update a lookup table and then run and update query
based on the lookup table and your other table. Join the region fields and
update the carrier field based on the value in the lookup table.

--
Duane Hookom
Microsoft Access MVP







- Show quoted text -

Can it be done by using a form or a report with out using an update
query- the users donot know how to use the look up table or update
query-

 

[Duane Hookom]

You would have a lookup table with the values and use this as the record
source of a continuous form. Add a command button that runs the update query.

 

[subs]

You would have a lookup table with the values and use this as the record
source of a continuous form. Add a command button that runs the update query.
--
Duane Hookom
Microsoft Access MVP






- Show quoted text -

i am new to Access. CAn you help me step by step- like creating a
continuous form and adding buttons? how to do that.Thanks

 

[Duane Hookom]

There is a wizard to create a continuous form. Build an update query and save
it with a name like "qupdRegionCarrier". The use the command button wizard to
add a command button that runs the update query.

 

[subs]

There is a wizard to create a continuous form. Build an update query and save
it with a name like "qupdRegionCarrier". The use the command button wizardto
add a command button that runs the update query.

--
Duane Hookom
Microsoft Access MVP






- Show quoted text -

Is it Forms-> New -> Wizard- ? i donot see any continuous forms or
even command wizard?

 

[Duane Hookom]

Create a continuous form. This is really fairly basic. When you attempt to
create a new form, you are presented with some form type options and a
dropdown list of tables/queries.