REPLACING BLANK FIELDS WITH DATA BASED ON ANOTHER FIELD

[DONNAK]

I added a field for an actual year - the old data is based on the yea
data as 98 99 00 01, etc. I was hoping I could find out how to fil
in this new blank field (lots of records) with the actual year dat
after I do a filter

 

[Jim C.]

Hi,

Use an update query. It should look something like this -

Update table
Set table.NewField = OldField + IIF(OldField > 10,1900,2000)

The 10 in the above can be whatever cutoff you want to use to split 1900 vs
2000 years.

Jim

 

[John Vinson]

On Wed, 04 May 2005 19:41:59 -0500,

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]