Checking for nulls and red-flagging your problems

[Kosmos]

Since people have been so helpful on this site I thought I'd contribute what little I can...since I am not a programmer but I'm working on an access database for work

The following code is an example of creating a variable Chk to which you assign a numeric value if a certain value is missing. If a certain field in a row is empty, then the chk number will return a value of 0-6. You can then arrange the chk number in ascending order so that any rows with missing values will show up at the top of your list and each number will correspond to a certain problem. If there are two numbers that are missing this will not work perfectly but at least all your problems will show up at the top of the list. You just insert this code into a field section of an append query. And have it insert into Chk or whatever you want to call it of some table for which you are designing the append query.

[PHP]Chk: IIf(IsNull([LastName]),0,IIf(IsNull([FirstName]),1,IIf(IsNull([AssetNumber]),2,IIf(IsNull([ProjectCodeList]),3,IIf(IsNull([ProjectCodeList2]),4,IIf(IsNull([ProjectCodeList3]),5,6))))))[/PHP]

[PEB]

The problem with this method is that you see the first fault in your field... Not all!

It's possible to use the fiunction Switch as more simple as syntax but the result will be different coz it will return the last wrong field

Take care about the way how you do the check!

:)