help with query

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

Can someone tell me how to do this. Create an upddate
query which prompts you for first name to be entered in
all lowercase and converts the text entered into all Upper
case. The value should go to the Firstname field (the
query must do formatting, no Input Mask). This query must
also ask you for a Last name to be entered in all lower
case. The value should go to Last name field and must have
a format of 1st letter upper case, the remaining letters
must be lower case (using Input Mask)
 
Well, an update query would look something like:

UPDATE Tablename
SET FirstName = UCase([Enter a First Name]),
LastName = StrConv([Enter a Last Name],3)

But I doubt that this is what you really want. This would set every record in
the table to the values you (or someone) inputs.

Queries won't allow you to control the input as to specifying Upper Case or
Lower case.

Do you want to replace what is already there in a record(s) (Update query) or do
you want to Add new records with the values you are specifying (Append query)?
 
I would like to update using the database I am working
with> Thank you for your help.
-----Original Message-----
Well, an update query would look something like:

UPDATE Tablename
SET FirstName = UCase([Enter a First Name]),
LastName = StrConv([Enter a Last Name],3)

But I doubt that this is what you really want. This would set every record in
the table to the values you (or someone) inputs.

Queries won't allow you to control the input as to specifying Upper Case or
Lower case.

Do you want to replace what is already there in a record (s) (Update query) or do
you want to Add new records with the values you are specifying (Append query)?

Can someone tell me how to do this. Create an upddate
query which prompts you for first name to be entered in
all lowercase and converts the text entered into all Upper
case. The value should go to the Firstname field (the
query must do formatting, no Input Mask). This query must
also ask you for a Last name to be entered in all lower
case. The value should go to Last name field and must have
a format of 1st letter upper case, the remaining letters
must be lower case (using Input Mask)
Click to expand...
.
Click to expand...
 
Jason,
I am sorry, but I do not understand what you want to do. Can you give a
specific example?


I would like to update using the database I am working
with> Thank you for your help.
-----Original Message-----
Well, an update query would look something like:

UPDATE Tablename
SET FirstName = UCase([Enter a First Name]),
LastName = StrConv([Enter a Last Name],3)

But I doubt that this is what you really want. This would set every record in
the table to the values you (or someone) inputs.

Queries won't allow you to control the input as to specifying Upper Case or
Lower case.

Do you want to replace what is already there in a record (s) (Update query) or do
you want to Add new records with the values you are specifying (Append query)?

Can someone tell me how to do this. Create an upddate
query which prompts you for first name to be entered in
all lowercase and converts the text entered into all Upper
case. The value should go to the Firstname field (the
query must do formatting, no Input Mask). This query must
also ask you for a Last name to be entered in all lower
case. The value should go to Last name field and must have
a format of 1st letter upper case, the remaining letters
must be lower case (using Input Mask)
Click to expand...
.
Click to expand...
Click to expand...
 
John, I am using a current database, I want to create and
save an update query, which will prompt me for my first
name to be entered in all lower case and converts the text
I enter into all Upper case. The value should go to the
Firstname field (without me utilizing the Input Mask).
This query must also ask me for my Last name to be entered
in all lower case. The value should go to the Last name
field and must have a format of 1st letter upper case, the
remaining letters must be lower case(I can utilize the
Input Mask)

Thank You for your help, Im new to all of this.
your help is appreciated.

-----Original Message-----
Jason,
I am sorry, but I do not understand what you want to do. Can you give a
specific example?


I would like to update using the database I am working
with> Thank you for your help.
-----Original Message-----
Well, an update query would look something like:

UPDATE Tablename
SET FirstName = UCase([Enter a First Name]),
LastName = StrConv([Enter a Last Name],3)

But I doubt that this is what you really want. This would set every record in
the table to the values you (or someone) inputs.

Queries won't allow you to control the input as to specifying Upper Case or
Lower case.

Do you want to replace what is already there in a
Click to expand...
record
(s) (Update query) or do
you want to Add new records with the values you are specifying (Append query)?


Jason wrote:

Can someone tell me how to do this. Create an upddate
query which prompts you for first name to be entered in
all lowercase and converts the text entered into all Upper
case. The value should go to the Firstname field (the
query must do formatting, no Input Mask). This query must
also ask you for a Last name to be entered in all lower
case. The value should go to Last name field and must have
a format of 1st letter upper case, the remaining letters
must be lower case (using Input Mask)
.
Click to expand...
Click to expand...
.
Click to expand...
 
-----Original Message-----
John, I am using a current database, I want to create and
save an update query, which will prompt me for my first
name to be entered in all lower case and converts the text
I enter into all Upper case. The value should go to the
Firstname field (without me utilizing the Input Mask).
This query must also ask me for my Last name to be entered
in all lower case. The value should go to the Last name
field and must have a format of 1st letter upper case, the
remaining letters must be lower case(I can utilize the
Input Mask)

Thank You for your help, Im new to all of this.
your help is appreciated.

-----Original Message-----
Jason,
I am sorry, but I do not understand what you want to
Click to expand...
do.
Can you give a
specific example?


I would like to update using the database I am working
with> Thank you for your help.
-----Original Message-----
Well, an update query would look something like:

UPDATE Tablename
SET FirstName = UCase([Enter a First Name]),
LastName = StrConv([Enter a Last Name],3)

But I doubt that this is what you really want. This
would set every record in
the table to the values you (or someone) inputs.

Queries won't allow you to control the input as to
specifying Upper Case or
Lower case.

Do you want to replace what is already there in a record
(s) (Update query) or do
you want to Add new records with the values you are
specifying (Append query)?


Jason wrote:

Can someone tell me how to do this. Create an upddate
query which prompts you for first name to be
Click to expand...
Click to expand...
entered
in
.
Click to expand...
.
Click to expand...
 
-----Original Message-----
-----Original Message-----
John, I am using a current database, I want to create and
save an update query, which will prompt me for my first
name to be entered in all lower case and converts the text
I enter into all Upper case. The value should go to the
Firstname field (without me utilizing the Input Mask).
This query must also ask me for my Last name to be entered
in all lower case. The value should go to the Last name
field and must have a format of 1st letter upper case, the
remaining letters must be lower case(I can utilize the
Input Mask)

Thank You for your help, Im new to all of this.
your help is appreciated.

-----Original Message-----
Jason,
I am sorry, but I do not understand what you want to
Click to expand...
do.
Can you give a
specific example?



Jason wrote:

I would like to update using the database I am working
with> Thank you for your help.
-----Original Message-----
Well, an update query would look something like:

UPDATE Tablename
SET FirstName = UCase([Enter a First Name]),
LastName = StrConv([Enter a Last Name],3)

But I doubt that this is what you really want. This
would set every record in
the table to the values you (or someone) inputs.

Queries won't allow you to control the input as to
specifying Upper Case or
Lower case.

Do you want to replace what is already there in a record
(s) (Update query) or do
you want to Add new records with the values you are
specifying (Append query)?


Jason wrote:

Can someone tell me how to do this. Create an upddate
query which prompts you for first name to be
Click to expand...
entered
in
all lowercase and converts the text entered into all
Upper
case. The value should go to the Firstname field (the
query must do formatting, no Input Mask). This query
must
also ask you for a Last name to be entered in all lower
case. The value should go to Last name field and must
have
a format of 1st letter upper case, the remaining letters
must be lower case (using Input Mask)
.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
That is what you said the first time. Saying the same thing again does not
increase my comprehension of what you are trying to do.

You can make an update query with two parameters, that is what the sample SQL I
gave you earlier would do, but AS I pointed out this will replace EVERY
firstname and lastname in your database. Is that what you want?

John, I am using a current database, I want to create and
save an update query, which will prompt me for my first
name to be entered in all lower case and converts the text
I enter into all Upper case. The value should go to the
Firstname field (without me utilizing the Input Mask).
This query must also ask me for my Last name to be entered
in all lower case. The value should go to the Last name
field and must have a format of 1st letter upper case, the
remaining letters must be lower case(I can utilize the
Input Mask)

Thank You for your help, Im new to all of this.
your help is appreciated.
-----Original Message-----
Jason,
I am sorry, but I do not understand what you want to do. Can you give a
specific example?


I would like to update using the database I am working
with> Thank you for your help.
-----Original Message-----
Well, an update query would look something like:

UPDATE Tablename
SET FirstName = UCase([Enter a First Name]),
LastName = StrConv([Enter a Last Name],3)

But I doubt that this is what you really want. This
would set every record in
the table to the values you (or someone) inputs.

Queries won't allow you to control the input as to
specifying Upper Case or
Lower case.

Do you want to replace what is already there in a record
(s) (Update query) or do
you want to Add new records with the values you are
specifying (Append query)?


Jason wrote:

Can someone tell me how to do this. Create an upddate
query which prompts you for first name to be entered in
all lowercase and converts the text entered into all
Upper
case. The value should go to the Firstname field (the
query must do formatting, no Input Mask). This query
must
also ask you for a Last name to be entered in all lower
case. The value should go to Last name field and must
have
a format of 1st letter upper case, the remaining letters
must be lower case (using Input Mask)
.
Click to expand...
.
Click to expand...
Click to expand...
 
Back
Top