I want to remove all part numbers that are a letter "T" or "P" under "PopCnd" that have no description under "PartStatusTwo." I want to do this in the script so they just don't show up at all.
If possible I would also want to do this for all part numbers that have no description under "PartStatusTwo" and are a "0" or "1" under "LC."
I've tried flagging these numbers as "REMOVE" in my expression to let myself know to take these out after exporting to excel, but I'm afraid I'm creating the world's largest IF statement and I know there's got to be a better way.
My mistake, I didn't pay enough attention to your code..
you're making a resident load from ths PartStatusTwo table, the field coming from this table is already named PartStatustwo.. so you shoud directly load Partstatustwo and use it on the where.
from the table rangemonths, I already changed the name of the field Months to MONTHS, when I use the old name using the Resident, it will not find it, because I should call it with the last name used via the alias.
