My head hurts from beating it against the monitor.
I'm trying to export a query to excel where it gives me a listing for a code, water, sewer, and account# and the water and sewer have to be 8 digits with leading 0's from a date span which I have working great thanks to the :notworthy HEROS :notworthy in this forum. Now my question is: Is it possible to get a total of the water and sewer amounts which have to be "text" so it doesn't truncate an amount that may be a even dollar amount? Does this make and cents to you?
I've posted the database to http://www.littlebitcountry.com/what_a_mess.zip it's 981K in size for anyone that could help me.