Categoring multiple criteria

[prabhu]

Hello all,

In my table i have mutiple criterias in one column like HE00, V00, -00 , STAT, VSTAT, HESTAT, -STAT, and lot more...

I want to categorise my databaser like the following

if its HE00, V00 and -00 then i want to give the category like NP

Like STAT, VSTAT, HESTAT, -STAT then i want to give the category like PN

For all the remaining i want to give SP

please help me on this...

 

[JamesMcS]

Probably easiest to use a number of update queries here. Have a look in Access help for correct usage.

 

[jdraw]

Try SELECT CASE statement.
Here is example

http://www.databasedev.co.uk/select-case-statement.html

 

[prabhu]

Thanks for your replies.

But is there any other way to do in query... i am not good in VB programming

 

[JamesMcS]

Yep - the update query route. Although a case statement isn't difficult....

If this is something you do regularly, just save the queries and stick them in a macro. Job done