Hey everyone,
I've got a question on SQL. I'm a novice and it's too complicated for me to do on my own.
I have a form with multiple fields and records (it's in datasheet view). Records are approved by entering a date in the [Approved] field. But I want to make sure users also fill in another field, [Number]. Sometimes it already has a value, but usually it's blank.
So the logic would work as follows:
for each record,
if [approved] is not null,
check [number]
if [number] is null,
msgbox "Please ensure that each approved record has a proper number associated with it."
else go to next record.
I realize this isn't crystal clear, and I'm hoping someone can help me put it together, or perhaps find an easier way to make this work.
Thanks!