Expression query

[dcarr]

Hello, is it possible to rename a field by using an expression. I am attempting to produce a make table query and instead of using the default column names SUMOfCharge and SUMOfVolume I would like to rename the fields Rev and Vol. Does anyone know the syntax? Thanks

 

[Mile-O]

Change the SQL statement so that parts like Sum([YourField]) become like Sum([YourField]) AS NewFieldName

 

[Mile-O]

Alternatively (but the exact same thing)


NewFieldName: YourField

 

[dcarr]

I tried your solution

The initial field was:

SumOfSIZETY

And after changing it the field was

SumOfSIZETY: Vol

When executed this prompted me for an input??? I just want it to replace SumOfSIZETY with Vol??

Any ideas?

Thanks

 

[Mile-O]

Vol: SIZETY


where you have a Sum total on the field.

 

[dcarr]

Cheers, superb!

 

[dcarr]

Hello Mile!!! I was wondering how you built up your vast knowledge of Access and if you could give any pointers on how to improve ones knowledge of the application??