Field Names in Queries 1

[netrusher]

I have some permanent queries in place from a dropdown and table on my form. My question is some of the Field names in the Query are big (wide). I know the Field Names come from the Field Names of the Table, but is there any way to change the field names on the Query manually so they can be shortened. In other words cheat the system.

Thanks in Advance!

 

[RoyVidar]

In the field part in the design view:

MyLongField: MyVeryLongFieldNameWhereIDontHaveSufficientSpace

In sql

Select MyVeryLongFieldNameWhereIDontHaveSufficientSpace as MyLongField, ....

Roy-Vidar