Hiya, me again. It is, perfectly within that DB, however, when I've now tried to bring it into my DB, the 'qryDailyPay_Not2018' is fine but as soon as I move onto 'qryWeeklyPay_Not2018_5orMore' I get -"Undefined function 'format' in expression" as an error message?