Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2011
    Posts
    31

    Unanswered: Renaming values for a field

    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?

  2. #2
    Join Date
    Jun 2011
    Posts
    31

    Cool

    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •