column heading 01, 02, 03... drops leading zero queries later

[denver1717]

I have a query in which the columns are text (Jan-Dec - so 01,02,03...,12).

I could rename the columns, but I have a lot built off of this query. I know exactly what the problem is when my other queries won't run (and go back and put the leading zero in the column and save it - then the other query will run) but I was hoping maybe someone would know how to retain the leading zero? I tried quotes, but all that does is put quotes in the column.

Thanks for any help!

[JoeM]

I am not sure I understand. If you format the field as Text instead of Numeric, your leading zeroes should be retained.

[ssanfu]

I am guessing that you have a table with field names 01, 02, 03,...,12. This is a poor design - the field names are not descriptive.
Since you keep having to "fix" a query, you should go ahead and fix the problem one and for all.
You say they represent months, so a better field naming scheme might be Mth01, Mth02, Mth03, ..., Mth12

There are apps, both free and for purchase, that will find and replace (all) references to a name.

I think there is:
"Speed Ferret" (about $99 ??) ..... http://www.speedferret.com/
"Find and Replace" (about $37) ..... http://www.rickworld.com/products.html
FMS Total Access Analyzer ($$).... http://www.fmsinc.com/

You could even try turning on "AutoCorrect", do the changes, and turn it back off...

Look for "Scan and replace utilities" section at: http://www.granite.ab.ca/access/thirdparty.htm

[denver1717]

I am not sure I understand. If you format the field as Text instead of Numeric, your leading zeroes should be retained.

The filed is an expression (01:round(sum[JanVol]),0) -or something along those lines. It retains the "01", but as I use other queries down the line eventually I get prompted for parameters for [01], [02], ... through [09], and it's because at some point those queries drop their zeros. All I have to do is go back, open the problem query and add the zeros to the 1-9 column, but I was wondering if anyone had had this happen to them, and had a fix.

I have gathered from the responses I have received that I need to redesign the column headings. I am cool with that - I am a beginner, but I plan to copy the database and start from there so I have the other as backup. I started a job that heavily uses Access last year, and a lot of our databases/queries are centered around what this one Access guru employee built (we have tables/queries named with 2003 that people refuse to change because so much is dependent on it). I'm thinking someone copied one of his databases over and started modifying it on his/her own.

Thanks for your help

[denver1717]

Thanks for your help! Will do! I also will definitely be putting more thought into naming my columns going forward. I have a hard time naming columns (though more so queries) with short names that are also reflective of what's going on (so that when I look back at the steps I understand what I was doing at the time), but it definitely is worth the time investment to do so.