jb,
thanks again for your advice. what i failed to do was check the date format on the computer where the query was saved originally - it turned out to be different than the format on the second computer, which i had checked. once i changed it and resaved the query, it worked fine.
cheers