Append an F to an field

[pokdbz]

I have a table that has a field called IdNumber and another field IdNumberF.
When a person enters the IdNumber on the form I need to transfer this number
into the IdNumberF field with an F appended to the end. How would I go about
doing this

IdNumber IdNumberF
123 123F

 

[Jason Rice]

One way that you could do this is to add a textbox to your form for the
IDNumberF field (you can set the visibility to false if you do not want to
user to see the field). Then use a procedure like this in an appropriate
event (i.e. On_Exit, On_Update, etc)

IDNumberF=IDNumber & "F"

HTH

 

[Rick B]

Why?

Seems kind of redundant. If you want to display the ID number with an F,
just do so in an unbound text field with something like...


=[IdNumber] & "F"



Proper database design would indicate that you don't store redundant
information.

 

[pokdbz]

The stats person wanted a 2nd field with this appended to it.

Why?

Seems kind of redundant. If you want to display the ID number with an F,
just do so in an unbound text field with something like...


=[IdNumber] & "F"



Proper database design would indicate that you don't store redundant
information.
--
Rick B

I have a table that has a field called IdNumber and another field IdNumberF.
When a person enters the IdNumber on the form I need to transfer this number
into the IdNumberF field with an F appended to the end. How would I go about
doing this

IdNumber IdNumberF
123 123F

 

[Rick B]

But again, that is not needed. They maight also want ten different fields
for the various formats of "name", but that is not needed. You build
variations of fields in the tables, queries, and reports, not in the table.
Your "stats person" should explain what end results they want, they should
not be telling you how to build the database.



--
Rick B

The stats person wanted a 2nd field with this appended to it.

Why?

Seems kind of redundant. If you want to display the ID number with an F,
just do so in an unbound text field with something like...


=[IdNumber] & "F"



Proper database design would indicate that you don't store redundant
information.
--
Rick B

I have a table that has a field called IdNumber and another field IdNumberF.
When a person enters the IdNumber on the form I need to transfer this number
into the IdNumberF field with an F appended to the end. How would I

go
about

doing this

IdNumber IdNumberF
123 123F

 

[pokdbz]

Thanks for the help.

But again, that is not needed. They maight also want ten different fields
for the various formats of "name", but that is not needed. You build
variations of fields in the tables, queries, and reports, not in the table.
Your "stats person" should explain what end results they want, they should
not be telling you how to build the database.



--
Rick B

The stats person wanted a 2nd field with this appended to it.

Why?

Seems kind of redundant. If you want to display the ID number with an F,
just do so in an unbound text field with something like...


=[IdNumber] & "F"



Proper database design would indicate that you don't store redundant
information.
--
Rick B



I have a table that has a field called IdNumber and another field
IdNumberF.
When a person enters the IdNumber on the form I need to transfer this
number
into the IdNumberF field with an F appended to the end. How would I go
about
doing this

IdNumber IdNumberF
123 123F