Using SQL switch function MS Access

[sandlucky]

Thanx 4 reply,
Ok, what abut using separate Table for "Plant Height" decoding? If I use 2 tables to decode 1 for Plant Height (S,M,T) and 1 for Habitats (A,B,C,D), How to join them all
(assume names of all 3 tables are Main, DecodeHeight, DecodeHabitat). Pls help me in doin Query,
Thanxalot 4 kind help sofa,

[pbaldy]

Did you try starting with the working 2-table query and adding the new table in design view as I suggested?

[sandlucky]

Thanx 4 quick reply!
Yaa, But not in design view. I'm doin it in SQL view.

[pbaldy]

You have many tools available to you. Why not use them? Switching between design view and SQL view is a good way to learn how to create SQL.