Access: Field Update Expression

[GeekDrew]

I have a database with field Banquet defined. I need to do the following:

If Banquet=0, then leave Banquet=0
If Banquet=null, then Banquet=1
If Banquet=>0, then Banquet=Banquet+1

I'm sure that there's a simple way to do this, but I can't figure it out... could be because it's now 2AM. Oh well....

Anyone?

 

[GeekDrew]

bump

 

[nickaskew]

Hi

Past this as SQL into a new query.. change "tblTest" to be the name of your table.

UPDATE tblTest SET tblTest.Banquet = nz([Banquet])+1
WHERE (((tblTest.Banquet)>0 Or (tblTest.Banquet) Is Null));

Regards

Nick

 

[GeekDrew]

Thank you VERY much, sir. I now have it working wonderfully. 🙂