Changing Field Names in Query when Exporting to Excel

[jamiesuperman420]

Hey!! I'm using Access 2000 and I'm exporting queries into Excel. Everything's working fine, but I'd like to change the field names when exporting. For example, in the query a field name is "JAN LS" but I'd like it to just be "JAN" when it's exported. Is there actually a way to do this??

Even changing the DISPLAYED field name in the Query would be fine - I can't figure out how to do it without renaming the actual field.

Thank you!!

 

[KenHigg]

Just put something like the following in the top column of the query builder:

Jan: [JAN LS]

See if that works - ?

 

[pbaldy]

Sure, it's called an alias. In design view:

JAN: [JAN LS]

in SQL view

[JAN LS] AS JAN

 

[KenHigg]

Ha - Beat you to it Paul

 

[jamiesuperman420]

haha... Thank you guys!! That's EXACTLY what I was looking for!! Thank you very much!!

Keep up the healthy competition

 

[pbaldy]

DANG! Slow fingers early in the morning, that's my excuse.