Input mask data not working in make table query

[Dnic]

I have data recorded using an input mask,
"RF">L\-0000;;*
to display data in the style: RFA-0001, RFA-0002 etc.

I have a make table query to join this field to another, to create a combo box look up.

Unfortunately, after I run the query, the only data from the input mask that gets imported is A0001, A0002 etc.

What have I done wrong? I guess the error must be in my specification for the input mask...

Any and all help gratefully received.

 

[Bat17]

the data is still stored as A0001 so you need to format it the way you want it in the query. add a column like
NewID: UCase(Format([id],"""RF""@-@@@@"))

HTH

Peter

 

[neileg]

By the way, you don't need to make a table to feed the combo, just use the select query as the combo's data source.

 

[Dnic]

Thanks Peter, I think that's got the query working.

I still don't understand why the data is not stored in the format:
RFA-0001
even though that is how I specified the input mask...

 

[Bat17]

Input mask really is just another format effect, remove the mask from the table and you will see that it is stored as typed. the mask is to make it easier to get the data typed in correctly