H
Helen
Can some one help me please, I have two problems. 1st- I
want to create an update query that prompts you (me) for
first name to be entered in all lower case and converts
the text that is entered into all Upper case. The value
should go to Firstname Field(the query must do the
formatting, without me utilizing the Input Mask). This
query must also ask you for a Lastname to be entered in
all lower case, The value should go to Lastname Field and
must have a format of 1st upper case, the remaining
letters must be lower case (you can do this with Input
Mask).
2nd- I want to create an Update query, which removes all
the spaces from the beginning of Field1 from a table.
3rd
I also am trying to figure out how to remove there are 3,
extra spaces that are in the field called Sentence in a
table. using an update query. and how to remove the same 3
spaces at the end of the field.
Thank You in advance for your assistance
Helen
want to create an update query that prompts you (me) for
first name to be entered in all lower case and converts
the text that is entered into all Upper case. The value
should go to Firstname Field(the query must do the
formatting, without me utilizing the Input Mask). This
query must also ask you for a Lastname to be entered in
all lower case, The value should go to Lastname Field and
must have a format of 1st upper case, the remaining
letters must be lower case (you can do this with Input
Mask).
2nd- I want to create an Update query, which removes all
the spaces from the beginning of Field1 from a table.
3rd
I also am trying to figure out how to remove there are 3,
extra spaces that are in the field called Sentence in a
table. using an update query. and how to remove the same 3
spaces at the end of the field.
Thank You in advance for your assistance
Helen