Search results

Hi All, I have an Excel formula that I need to convert to Access 2007: =IF(F8="Active",IF(AND(C8<>"None",C8<>"COM"),VLOOKUP(N8,AQ6:AV11,L8+1,FALSE ),IF(C8="COM",VLOOKUP(J8,AX7:AY11,2,),"Error")),"Null") The vlookup looks to this: AQ6:AV11 1 2 3 4 5 5 11 16 20 23 25 4 7 12 17 21 24 3 4 8 13...

Hi All, I've got a form where I want a date field to automatically change the date if any of the data on a row is changed or added. I've found a similar thread before but unfortunately I couldn't get it to work. Private Sub Form_AfterUpdate() Me.Last_Updated = Now() I really don't want...