REPLACING BLANK FIELDS WITH DATA BASED ON ANOTHER FIELD

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DONNAK - 05 May 2005 01:41 GMT

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

Reply to this Message

Jim C. - 05 May 2005 17:14 GMT

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

> 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.

Reply to this Message

John Vinson - 07 May 2005 00:48 GMT

>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]

Reply to this Message