Re: REPLACING BLANK FIELDS WITH DATA BASED ON ANOTHER FIELD
- From: John Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 06 May 2005 17:48:01 -0600
On Wed, 04 May 2005 19:41:59 -0500,
DKABEARY@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx (DONNAK) wrote:
>I added a field for an actual year - the old data is based on the year
>data as 98 99 00 01, etc. I was hoping I could find out how to fill
>in this new blank field (lots of records) with the actual year data
>after I do a filter.
Could you give us a little help here? Bear in mind: we do not know the
structure of your tables, what the old data look like, how this new
field should be filled in, where you're getting the actual year
data...
Please describe the structure of your table. I'm sure an Update query
will do the trick but can't begin to suggest how to create it.
John W. Vinson[MVP]
.
- References:
- Prev by Date: Re: Database with Pictures
- Next by Date: Help! - Table design: Normalization and subclassing questions
- Previous by thread: RE: REPLACING BLANK FIELDS WITH DATA BASED ON ANOTHER FIELD
- Next by thread: Need some comments on current table setup
- Index(es):
Relevant Pages
|
