I know I should have posted this on the Excel forum, however, there are many Access gurus who are also Excel gurus, however, not as many Excel gurus also know Access gurus so they may not be aware of the functions in Access.
By the way, if you weren't able to assist me, you probably shouldn't...