How do I create a field that will lookup and display text from another field...

[Fitch]

I don't even want to know why you're doing this, but here you go:

Max(Date used1, Date used2,..., Date used 10)

[Tom England]

Why don't you just use the AutoEnter last modification date option?

[pborelli]

It's more complicated than what my subject suggests. I have 10 fields, named

Date used1, Date used2,..., Date used 10.

For each new record, users will fill in the Date used1 field with the date they used that record. Each time they go to that record, they will keep filling in the next Date used field.

So, what I need is a field that will take the last Date Used field that was filled in (the most recent one) and display that info on the right hand column. This way, I can scroll through the list and easily see when each record was last used.

What is the best way to do this?

Thanks!

Patrick

[ April 10, 2002, 07:51 AM: Message edited by: pborelli ]

[pborelli]

Thanks for the Max (Date Used1,...) suggestion. It worked perfectly.

I have basically the same problem and for some reason, I can't figure it out.

I have 10 fields, non-repeating, titled Dept 01, Dept 02, Dept 03.... These fields are used by various depts to track when they used something. So, if the art dept. used something, they woiuld type in the date in Date Used1, and type in "Art" in Dept 01. If someone else uses the same thing two weeks later, they would type in the date in Date02, and their dept name in Dept 02. That way, we can see who used what, when.

Now, this is all working fine but I had wanted to track, on the far right side of the layout, the last dept and the last date something was used. The suggestion of creating a field based on the Max (date01, date02) works--it displays the newest date

on the right hand side, so I can see the last date something was used.

I tried this Max (dept 01, dept 02,..., dept 10) to track the last dept to use something but it just displays a "0" (and I made sure that the field was displaying text and not a number).

Help!

Thanks.

Patrick