Good afternoon experts,
I have a table called dbClinics, that populates a combobox. When the record is saved in the main table, dbMaster, it saves the cID instead of the ClinicName. I am trying to write a SQL query that looks something like:
SELECT [Last Name] & ", " & [First Name] AS FullName, [Anti-Terrorism] AS [Expiration Date], [Section]
WHERE Category='MIL' And [cbAnti-Terrorism]=-1 And [Anti-Terrorism]<=date();
This query works just fine, however, the [section] is giving me the cID and I want the ClinicName. Any suggestions?