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!

Use an alias. In the top row of your query column put something like this:

Short Name: TheActualLongNameOfYourFieldGoes Here

Now you wil see Short Name in the query or wherever you use the query as a Row or Record Source.

hth,
Jack

You could also use the Caption property for those fields in Table design.

In the query design screen select properties and click on the field column.
You will the be able to set the caption property for that field in that query.