Turn Off Access Field Re-name? Calculation fields in query

  • Thread starter Thread starter Can Of Worms
  • Start date Start date
C

Can Of Worms

I am wondering if there anyone has found a method for 'turning off' how
Access auto-renames a field that has a calculation against it.

For example, fi you are grouping on [Field1], and Summing [Field2], then the
query results show the data from [Field1] and [SumOfField2]. I just want to
leave it [Field2].

I understand, and use all the time, the renaming method of Field2: Field2 to
keep it with the same name, but I can count on 1 hand the number of times I
was fine with the "SumOf" appendage. It has become a fairly significant drain
on time and levels of calm having manually rename field after field after
field after field in query after query after query.... you get the idea.

Just one addition of the appendage is irritating enough, but I frequently
have to go back and rename in multiple queries, to avoid
[AvgOfSumOfSumOfField2] type names.

I would much prefer keeping the actual field name, and renaming to add the
SumOf (or whatever) appendage as needed...like maybe once a year.

SQL should still be Sum of [Field2] As [Field2], but I don't see why Access
has to deliberately add in the additional text, and I want to make it stop.

Currently using Access 2003.

Thanks.
 
I don't see why Access has to deliberately add in the additional text,
It has to do that to be able to distinguish between the fields.
You can apply a different name if you want to by editing the field row in
design view like this --
FIELD -- My_Field1_Sum: Field2
TABLE --
TOTAL -- Sum
SORT --
SHOW -- √
CRITERIA --
 
There is a work around this...you can copy all the query (in SQL View) to a notepad and use the Replace tool in the notepad to relace the word you don't want (like SumOf) and then copy the query back to the MS Access and it works fine...
 
Back
Top