Hi, first post, and am a real novice, looking at the problems and solutions posted here.
I have a database (Access 2003) where I want to change the name of a field within a query (to be used in forms and reports), depending on a decision the user makes. Can't find a way to do it. Can you help?
A marking system; I have tbl_students and lots of units, thus tbl_unit_01, tbl_unit_02, etc.
Within tbl_students I have field including "coreclass" and "optionclass". I have the user choosing to assign core classes or option classes to the various units (using docmd.runsql) running various action queries to populate the tbl_unit_01 etc. So far so good. But have a set of queries, one for each unit; qry_unit_01, qry_unit_02, etc. In these I have 'coreclass' and 'optionclass', but want to rename one of these (depending on user's choice) to 'class'. Can you help?