COMPARE FIELDS

[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:

Time Quantity Time Of Next Purchase
1:22:36 AM 3 0
1:23:36 AM 2 1
1:30:36 AM 1 7
How can I obtaine the answer in the field named Time Of
Next Purchase?, What is the expression that needs to be
used in Microsoft Access 2000?. Please I need help on this
matter urgently.

 

[Rick B]

Not sure what your question is. To display the value in the "Time Of Next
Purchase" field in a query, simply pull that field into your query. You
will have to tell us what you are tring to accomplish here in a bit more
detail.

Rick B