Hello, I have this simple SQL query:
SELECT Imported.[Call Number], Imported.ID, Imported.[Reprint Edition], Imported.[Reviewed Item], Imported.PPopulation, Imported.DDesign1, Imported.O1Outcome1, Imported.D2Design2, Imported.O2Outcome2, Imported.NTotal, Imported.SpecialPop, Imported.NRD, Imported.NRO1, Imported.NRO2, Imported.NDE, Imported.SMN
WHERE (((Imported.[Reprint Edition])='get'));
I want to make it a bit more complicated by adding some if/then statements but I am having a hard time getting it to work. The fields PPopulation, DDesign1, O1Outcome1, D2Design2, O2Outcome2 are all 'yes/no' fields and NTotal is a numeric field.
I want to make a decision tree like the image in the screen shot. Where, for example if PPopulation, DDesign1, and O1Outcome1 are all yes then Reviewed Item is equal to INC. Could anyone show me an example of how to do this?