HELP! Im lost!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a novice at any kind of programming, however I know Access pretty well.
I am trying to write a code to put the current time in one of two different
fields, based on the last record in the query. For example; if the last
record has the time posted in field 1 then in the current record the time
will be posted in field two.
Any ideas?
 
Dragon_Silveroak said:
I am a novice at any kind of programming, however I know Access
pretty well. I am trying to write a code to put the current time in
one of two different fields, based on the last record in the query.
For example; if the last record has the time posted in field 1 then
in the current record the time will be posted in field two.
Any ideas?
Click to expand...

Doable, but odd. You'll have to define what you mean by "last record",
since the ordering of records is arbitrary unless you impose an order by
explicitly sorting the records. And when -- that is, at what point in
processing -- would you want to do this? If you're entering records on
a form, every time after the first record in the session, you can easily
know what was done on the previous record. The first record is another
matter.

Can you explain what purpose you hope to serve by this? As I said, it
seems odd to be switching from field to field like that.
 
Back
Top