update simultaneously a field in a group of records
- From: "GL" <GL@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 6 Jun 2005 13:40:03 -0700
Hi
I use a database to manage the items used in a project.
I use an Items table with the fields of ItemCode, Category, Model, Location,
UsePeriod, VendorID and Cost and a related Vendors table with the relevant
fields.
Many of these items are of the same category and model and provided by a
vendor. So it is not effective to type the cost for each item one by one on
each record, but it should be better enter it once for each item that
presents and updates? all the same ones of the same category, model and
vendor after all of them have the same cost.
Do you have any suggestion how to do this?
Thanks in advance
GL
.
- Follow-Ups:
- Re: update simultaneously a field in a group of records
- From: John Vinson
- Re: update simultaneously a field in a group of records
- Prev by Date: Subquery for calculated field - probs with crosstab
- Next by Date: creating a multi part query to be able to export complete data
- Previous by thread: Subquery for calculated field - probs with crosstab
- Next by thread: Re: update simultaneously a field in a group of records
- Index(es):
Relevant Pages
|
