Search results

Hi, Trying to add a value of 1 if yes using the following but I'm getting an error in the field when I run the query? Can anyone help please? Yes: IIf([Successful]="Yes","1","0") Thanks in advance! Adam

Hi, Sorry new to this site and haven't touched Access for over 10 years! Have tried to search for an answer thought it maybe DAvg but can't get the syntax correct and keeps crashing my Db. Anyway I have a query which counts number of passengers either successful or not. Date | Flight No|...