Compare Fields

  • Thread starter Thread starter RITRAM
  • Start date Start date
R

RITRAM

I have been tasked to do this program that should compare
data that are on the same field. On the following example
it would be shown ideally what the answer should be:

Purchase Time Time Frame
1 1:22:36 AM 0
2 1:23:36 AM 1
3 1:30:36 AM 7

I need to compare the time frame between Purchase number 1
with Purchase number 2, Time Frame between Purchase number
2 with Purchase number 3, etc.


How can I obtaine the answer in the field named Time
Frame? What is the expression that needs to be
used in Microsoft Access 2000?. Please I need help on this
matter urgently.
 
Back
Top