Access update

[Guest]

I have a database of 2000 names and information. Each entry includes the
grade in school. How can I change the grade for all entries by one year?

 

[Arvin Meyer [MVP]]

I have a database of 2000 names and information. Each entry includes the
grade in school. How can I change the grade for all entries by one year?

Easy enough. Use an Update query:

UPDATE YourTable SET GradeField = [GradeField]+1;
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Naresh Nichani]

Hi:

Create an update query with this sql.
-----------------------------------
UPDATE [Table1] SET [Table1].[MyDate] = DateAdd("yyyy",1,[MyDate]);
------------------------------------

Detailed Steps -

1. First click the Query tab and click New.
2. Select Table you want to Update
3. Click View | SQL View
4. Paste the SQL statement above. Replace Table1 with the name of your
table. This is in two places in the SQL.
5. Replace MyDate with the name of the field to update.

FYI - this will increment all dates in field MyDate by 1 year (increase by
1 year). This cannot be Undone. So backup database before doing this.

Save the query and close query window. Double click query to run the Update.

Regards,

Naresh Nichani
Microsoft Access MVP

 

[Joseph Meehan]

I have a database of 2000 names and information. Each entry includes
the grade in school. How can I change the grade for all entries by
one year?

An interesting situation. Generally I would suggest that you should
record the school year they began their education and then assume that they
all progressed one year each year, but since that may not be true, I guess
your approach may be the best. As noted use an update query.

 

[Larry Daugherty]

Are social promotions so well locked into the fabric of the
"education" system that the possibility of repeating a grade no longer
exists?

Run an Update Query on the table with the grades.

HTH
--
-Larry-
--

I have a database of 2000 names and information. Each entry includes the
grade in school. How can I change the grade for all entries by one

year?