i have been able to rely on ms access for years, but job duties are getting a bit more cumbersome and trying to delve into the sql world. in access all you have to do to rename a field name in the query setup is "new field name":"current field name" - basically monkey work. how is it done in an sql statment? for instance if the field in quest is "run_yr_mo" and is sourced from a table call "mtgmgr.acct.mstr" and i want the field name to display as "DATE" when the query results are returned, what is the command sequence? help features seem to indicate the following:
SELECT MTGMGR.ACCT_ACCTMSTR.RUN_YR_MO as [DATE] . . .