Update query, fill a field in all records

[Rick Tidd]

I have a table in which I would like to be able to change the quantity field
with user input.
I have tried an update query, using a parameter, however it does not update
the field.
I want to be able to change the quantity field, as this is an estimator
database, and I need to have user input to fill all the fields in all the
records in this database.
Any suggestions would be helpful
Rick

 

[John Spencer]

Basically, the following should work

UPDATE SomeTable
SET SomeField = [What is the new value?]

Can you post the SQL of the Update query that did not work?
Did you get an error?
How did you run it? If you simply switched views, that does not run the
query. You need to use Query: Run from the menu or Press the Red
exclamation button. Switching from design view to datasheet view only
shows the potential records to be updated, it does not actually execute the
update.

 

[Rick Tidd]

Name of table 2ndlocationcolors
Name of field to update qty

In query I have:
Field: qty
Table 2ndlocationcolors
Update to: "UPDATE 2ndlocationcolors SET qty"=[What is the new value?]
Criteria: Blank

Upon running the query it says it is going to update the correct number of
rows, however instead of the number input, qty is set to zero.

I know there is something simple that I am not doing.

Any suggestions?
Thanks

Basically, the following should work

UPDATE SomeTable
SET SomeField = [What is the new value?]

Can you post the SQL of the Update query that did not work?
Did you get an error?
How did you run it? If you simply switched views, that does not run the
query. You need to use Query: Run from the menu or Press the Red
exclamation button. Switching from design view to datasheet view only
shows the potential records to be updated, it does not actually execute the
update.

I have a table in which I would like to be able to change the quantity
field
with user input.
I have tried an update query, using a parameter, however it does not
update
the field.
I want to be able to change the quantity field, as this is an estimator
database, and I need to have user input to fill all the fields in all the
records in this database.
Any suggestions would be helpful
Rick

 

[John Spencer]

In the query grid, all you should need would be:

Field: qty
Table 2ndlocationcolors
Update to: [What is the new value?]
Criteria: Blank

Name of table 2ndlocationcolors
Name of field to update qty

In query I have:
Field: qty
Table 2ndlocationcolors
Update to: "UPDATE 2ndlocationcolors SET qty"=[What is the new value?]
Criteria: Blank

Upon running the query it says it is going to update the correct number of
rows, however instead of the number input, qty is set to zero.

I know there is something simple that I am not doing.

Any suggestions?
Thanks

Basically, the following should work

UPDATE SomeTable
SET SomeField = [What is the new value?]

Can you post the SQL of the Update query that did not work?
Did you get an error?
How did you run it? If you simply switched views, that does not run the
query. You need to use Query: Run from the menu or Press the Red
exclamation button. Switching from design view to datasheet view only
shows the potential records to be updated, it does not actually execute
the
update.

I have a table in which I would like to be able to change the quantity
field
with user input.
I have tried an update query, using a parameter, however it does not
update
the field.
I want to be able to change the quantity field, as this is an estimator
database, and I need to have user input to fill all the fields in all
the
records in this database.
Any suggestions would be helpful
Rick

 

[Rick Tidd]

John,
Thanks very much! I new it was probably simple, however I am new at this.
Thanks again, it worked perfectly!
Rick

In the query grid, all you should need would be:

Field: qty
Table 2ndlocationcolors
Update to: [What is the new value?]
Criteria: Blank

Name of table 2ndlocationcolors
Name of field to update qty

In query I have:
Field: qty
Table 2ndlocationcolors
Update to: "UPDATE 2ndlocationcolors SET qty"=[What is the new value?]
Criteria: Blank

Upon running the query it says it is going to update the correct number of
rows, however instead of the number input, qty is set to zero.

I know there is something simple that I am not doing.

Any suggestions?
Thanks

Basically, the following should work

UPDATE SomeTable
SET SomeField = [What is the new value?]

Can you post the SQL of the Update query that did not work?
Did you get an error?
How did you run it? If you simply switched views, that does not run the
query. You need to use Query: Run from the menu or Press the Red
exclamation button. Switching from design view to datasheet view only
shows the potential records to be updated, it does not actually execute
the
update.


I have a table in which I would like to be able to change the quantity
field
with user input.
I have tried an update query, using a parameter, however it does not
update
the field.
I want to be able to change the quantity field, as this is an estimator
database, and I need to have user input to fill all the fields in all
the
records in this database.
Any suggestions would be helpful
Rick