F Farkyss Feb 26, 2010 #21 Sorry, yes, was a typo in copying - 999789 in that line - double checked it by running it with such
V vanderghast Mar 1, 2010 #22 Can you try the same query in MS SQL Server (whatever edition you have, some are free)? If so, and if you get the same result, then all would point out that the problem is with the data. Vanderghast, Access MVP
Can you try the same query in MS SQL Server (whatever edition you have, some are free)? If so, and if you get the same result, then all would point out that the problem is with the data. Vanderghast, Access MVP