Recent content by jordinho
-
J
IIF function as query criteria
help i need some help with IF statements in access. I have been asked to set up a query to calculate total duration in additional learning support. the scenario is if the number of hours is less than 13 then that student is in band one. and if its greater than 13 its band two and so on. This... -
J
IF Statement help
help i need some help with IF statements in access. I have been asked to set up a query to calculate total duration in additional learning support. the scenario is if the number of hours is less than 13 then that student is in band one. and if its greater than 13 its band two and so on. This...