Field Problem

  • Thread starter Thread starter Cliff Waters
  • Start date Start date
C

Cliff Waters

Can anyone please help me with this problem?

I have 3 fields on a form: 1st Attempt, 2nd Attempt, 3rd Attempt. What I
need is a 4th field to show the latest attempt How can I make the forth
field lookup to see what attempt was the latest.

I hope that you understand what I am trying to do

Thanks for any help


Cliff
 
Cliff

Not sure how this is a .queries 'group question... You might get more
response posting in the .forms 'group.

By the way, without some idea of your underlying data structure, it could
be tough to offer a way to use that data in your form.

Good luck

Jeff Boyce
<Access MVP>
 
Cliff Waters said:
Can anyone please help me with this problem?

I have 3 fields on a form: 1st Attempt, 2nd Attempt, 3rd Attempt. What I
need is a 4th field to show the latest attempt How can I make the forth
field lookup to see what attempt was the latest.
Click to expand...

First off, I'm a newbie here myself so this is just me thinking aloud!

Secondly, could you create some sort of temporary table which has in it the
3 attempts so far and a field for each attempt which automatically defaults
to the current date and time (long format so you get the time). Then you
could query that to find the most recent date/time, lookup the corresponding
attempt value and have the 4th field on your form get the result of your
query.

I think that's how I would go about doing it, not sure about the actual
methods to get it to work. Perhaps somebody else could help here. I could
probably work it out but it might take me a few days.

Sorry I can't be of more help, hope you get it sorted though!

Raist.
 
Back
Top