So the original table has like 20 columns. I only want to care about 4 of the columns. I was trying to create an output table that...

I just don't understand how to get the results? How many records are rank 1, how many are rank 2... how many are rank 16? I can create...

Reading that it seems like Switch() is the better choice than nesting IIfs. Do you know if Switch() will work in Oracle? We will be moving our Database...

The Switch() function worked. I had tried nesting IIf before I posted asking for help. It kept returning errors and the cursor was stopping at the , like...

Someone on another forum gave me the answer:

UPDATE CovElig

SET CovElig.GrpNmeCd = Switch(Mid([GrpName],10,1)="S","001", Mid([GrpName],10,1)="B","006", Mid([GrpName],10,1)="","910")

WHERE Mid([GrpName],10,1) In ("S","B","");

It doesn't work. I googled CASE in Access and it said it can only be used in VBA code. I am using SQL code in Access. I don't know...

I get "syntax error (missing operator) in query expression 'CASE WHEN...." etc error.

You're a genius!!! Thank you so much. That worked and deleted all the records I need it to.

Changing DELETE * FROM CovElig to SELECT * FROM CovElig returns the records I want to delete. Its like I can't have a join in the where clause for...

I'm sorry I thought i posted the error. It says "specify the table containing the records you wish to delete". I want them to delete from CovElig. I...