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!!

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

Jan: [JAN LS]

See if that works - ?

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

JAN: [JAN LS]

in SQL view

[JAN LS] AS JAN

Ha - Beat you to it Paul :p

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

Keep up the healthy competition ;)

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