I managed to implement some validation rules using wildcard characters to account for variations in spelling for different examinations but i would like to now assign a standard name of exam for all records from the query in a new field....
eg. Taking all variations for Lumbar Spine X-Rays Anterior-Posterior, such as Lum Spine AP or LSP AP and treating them as "LSPINE AP" as the new name in a field to itself assigned to each record.
How would i go about defining this new field in a query based on results from the previous query which returned all the variations in spelling?
This is getting ridiculous...everytime i post my question on this forum i go back to it and try summin new and it works....turns out all i had to do was specify the new name of the fields as " Examination: "LSPINE AP" " and it assigns that name to be displayed for all the records..yay me!