Interesting - I'll give that a go.


The other thing that occurred would be to run the Access query from excel and get it to make a table, then link to that.


Just a shame you can't have a function on the Access side.


Thanks for your reply!