Hiding numbers during output from query

[Lifeseeker]

Hi,

Would it be possible to output a column of data that is masked?

For example, if I have a column that stores personal identify information(unique 5-digit number), and when exported we would like to hide the digit, is it possible?

I'm thinking....to have 1 = a, 2 = b, 3 = c, etc.

When doing the analysis, we don't want to easily see the 5-digit number.

Can be this done in Access at least?

Any comment/thought is much appreciated

 

[John Big Booty]

With your query in design view set the Input Mask property of the field you wish to obscure to Password. You may need to right click the design grid and select the Properties window.

 

[Lifeseeker]

Re: Turning numbers into letters during output from query

With your query in design view set the Input Mask property of the field you wish to obscure to Password. You may need to right click the design grid and select the Properties window.

Thanks.

I was wondering if it was possible at all to manually obscure digits.

So for example, we want all the 1s turn into a, all the 2s turn into b on the output so that we can actually go back to them if necessary without having to know what each "password" represents.

Does this make sense?

Thanks for any comment/input on this.

 

[John Big Booty]

You could use the Replace() Function