Query help

[subs]

Please help with this

OST Ocity Dst Dcity Field1 Carrier1
MI kalamazoo NJ Parsippany EC
OH Cincin MA Boston EC
NJ Dover MI Detroit MW
OH Columbus OH Cincinnati MW
NJ Dover MA Boston EC
OH Columbus MI Detroit MW
OH Cincin MA Boston EC

first of all the query should ask for two inputs- [enter the EC
carrrier] , [enter the MW carrier]. And then based on those answers
and also whether field1 is EC or MW , the Carrier1 should be updated.

Example

Enter the ec carrier- Saia
Enter the mw carrier- rl

So the field Carrier1 should be

Saia
Saia
rl
rl
saia
rl
saia

Is there a one line SQL ?

 

[Jeff Boyce]

If you open a query design window and use the grid to do what you've
described, you can then click on the design tool/SQL View to see the SQL
equivalent.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[subs]

If you open a query design window and use the grid to do what you've
described, you can then click on the design tool/SQL View to see the SQL
equivalent.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Please help with this

OST Ocity      Dst Dcity      Field1       Carrier1
MI kalamazoo     NJ Parsippany      EC
OH Cincin     MA Boston       EC
NJ Dover     MI Detroit      MW
OH Columbus     OH Cincinnati       MW
NJ Dover     MA Boston      EC
OH Columbus     MI Detroit      MW
OH Cincin     MA Boston      EC

first of all the query should ask for two inputs- [enter the EC
carrrier]  , [enter the MW carrier]. And then based on those answers
and also whether field1 is EC or MW , the Carrier1 should be updated.

Example

Enter the ec carrier-     Saia
Enter the mw carrier-    rl

So the field Carrier1 should be

Is there  a one line SQL ?- Hide quoted text -

- Show quoted text -

No Jeff- I need help with the sql statement- what would be the sql
statment which can update the carrier field

 

[Jeff Boyce]

I understood that. I offered a way for you to build a query that does what
you want, then get and use the SQL statement for whatever other purpose you
might have.

If you are looking for a SQL statement 'from scratch', and want someone else
to write it for you, perhaps one of the other newsgroup readers can help.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

If you open a query design window and use the grid to do what you've
described, you can then click on the design tool/SQL View to see the SQL
equivalent.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Please help with this

OST Ocity Dst Dcity Field1 Carrier1
MI kalamazoo NJ Parsippany EC
OH Cincin MA Boston EC
NJ Dover MI Detroit MW
OH Columbus OH Cincinnati MW
NJ Dover MA Boston EC
OH Columbus MI Detroit MW
OH Cincin MA Boston EC

first of all the query should ask for two inputs- [enter the EC
carrrier] , [enter the MW carrier]. And then based on those answers
and also whether field1 is EC or MW , the Carrier1 should be updated.

Example

Enter the ec carrier- Saia
Enter the mw carrier- rl

So the field Carrier1 should be

Is there a one line SQL ?- Hide quoted text -

- Show quoted text -

No Jeff- I need help with the sql statement- what would be the sql
statment which can update the carrier field