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| Successful | PaxTotal
31/07/2019 | BZ0001 | Yes | 150
31/07/2019 | BZ0001 | No | 5
To avg so (5/150)*100
But how do I do this when the values are in the same column? I have tried to create 2 seperate queries and then join them together but that doesn't work either.
Would be grateful for some help!
Thanks
Adam
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| Successful | PaxTotal
31/07/2019 | BZ0001 | Yes | 150
31/07/2019 | BZ0001 | No | 5
To avg so (5/150)*100
But how do I do this when the values are in the same column? I have tried to create 2 seperate queries and then join them together but that doesn't work either.
Would be grateful for some help!
Thanks
Adam