Steve Turner
sturner at mseco.com
Wed Oct 8 09:29:23 CDT 2008
Helo list, I have a couple of querys that calculate a total by date range. They were pretty complicated but they were working until I went in and changed the date criteria trying to get the date exported to a VBA parameters query. The formula had a Round(formula,2). Worked fine for a while but I changed the date criteria to a GetValue() and when I went back in to change the date criteria again it gave me a compile error and showed the SQL code and I couldn't get to the Datasheet View. Finally found that the round function was the problem. Deleted the round reference and it would let me save it. Tried to go back and add it but It won't let me now. Anyone know of such a problem? Steve A. Turner Controller Mid-South Engineering Co. Inc P.O. Box 1399 Hot Springs, AR 71902 E-Mail: sturner at mseco.com and saturner at mseco.com Phone:(501)321-2276 Fax: (501)321-4750