Hi,
Hope this is the correct section... it covers a bit more than just tables.
We have a large health database, with several data entry individuals, that has run for many years.
I use input mask >aC to force the table entries to appear as though sex is F or M even if entered accidently or in the past as "f" or "m" and also >aCCCCCCCCCC to make all names consistently in capitals.
I use > in formatting to be sure reports from the table are printed as capitals.
Access looks wonderful
Frustrating me is that when I export the Access database into my statictics program for analysis, physically what was originally entered is exported e.g Smith, SMITH, smith, smiTH. I want it to appear as only SMITH in my export.
Currently to data clean, I remove the masks and physically go through the data to ensure consistency before exporting.
Is there anyway other than this?
Cheers
Alex
Hope this is the correct section... it covers a bit more than just tables.
We have a large health database, with several data entry individuals, that has run for many years.
I use input mask >aC to force the table entries to appear as though sex is F or M even if entered accidently or in the past as "f" or "m" and also >aCCCCCCCCCC to make all names consistently in capitals.
I use > in formatting to be sure reports from the table are printed as capitals.
Access looks wonderful

Frustrating me is that when I export the Access database into my statictics program for analysis, physically what was originally entered is exported e.g Smith, SMITH, smith, smiTH. I want it to appear as only SMITH in my export.
Currently to data clean, I remove the masks and physically go through the data to ensure consistency before exporting.
Is there anyway other than this?
Cheers
Alex