simple SELECT CASE statement

[Lifeseeker]

Hi there,

I have a simple SELECT CASE query that I need help with. I'm not sure how the syntax goes and I want to learn about it.

In the attached file, if you click on "cohort table", you will see the categorization for each unit under "field1".

how will I be able to use a SELECT CASE statement in a query to populate each unit with assigned category?

Any help is appreciated.

Thanks

 

[pbaldy]

You would typically join that table to other tables that contained the Unit. There is no SELECT CASE in queries. There's Select/Case in VBA, but it isn't really appropriate to what I assume you're trying to do.