Search results

Hi, I am trying to run formula field a query to produce a particular date: [Date]: IIf([Document_Number]=1,"03 Jan 07") When I try to develop the formula further: [Date]: IIf([Document_Number]=1,"03 Jan 07"),(Document_Number]=2,"23 Aug 07")) etc... A syntax error formula appears. Can...

Mods - feel free to change the title of the thread to suit. Hi, I'm not fully conversant with access and I've only been using it for a week! The spreadsheet I have been using has become far too big with over 52 columns and 2500 rows of data - hence my question. (I've attached a screenshot to...