Renaming field in query

[alecgreen]

Hi, I am trying to change the name of a field [OrderAnalysisCode] in
my query to something that is more relevant, but when I try
DeliveryLocation: [OrderAnalysisCode] and run the query
OrderAnalysisCode shows as the field heading when I expected
DeliveryLocation. Im sure I have done this before!

Thanks

Alec

 

[Amy Blankenship]

Hi, I am trying to change the name of a field [OrderAnalysisCode] in
my query to something that is more relevant, but when I try
DeliveryLocation: [OrderAnalysisCode] and run the query
OrderAnalysisCode shows as the field heading when I expected
DeliveryLocation. Im sure I have done this before!

What does the SQL of the query say?

It should say [OrderAnalysisCode] AS DeliveryLocation.

HTH;

Amy

 

[Marshall Barton]

Hi, I am trying to change the name of a field [OrderAnalysisCode] in
my query to something that is more relevant, but when I try
DeliveryLocation: [OrderAnalysisCode] and run the query
OrderAnalysisCode shows as the field heading when I expected
DeliveryLocation. Im sure I have done this before!

Check the field's Caption propery.

 

[alecgreen]

Hi, I am trying to change the name of a field [OrderAnalysisCode] in
my query to something that is more relevant, but when I try
DeliveryLocation: [OrderAnalysisCode] and run the query
OrderAnalysisCode shows as the field heading when I expected
DeliveryLocation. Im sure I have done this before!

Check the field's Caption propery.

Thats it! Thank You