I have a query with a number of records in it. One of the fields in the query is for employee Job Titles. How can I specify EXACTLY which order I would like these job titles displayed in? For example: Some titles are "ELEC" or "MW" or "HEATER" however I do not want them in either Ascending or Descending order, I want to be able to specify "HEATER" than "ELEC" than "MW" etc. etc.

You need to add a new column to the JobTitles table (or create a new table if you don't already have one for this purpose). The new column would contain a sort value. Then for your reports or combo boxes join the main table with the JobTitles table (using a left join) to get the SortValue column and use that in the order by clause.