Subtract in the same field

  • Thread starter Thread starter Jenna
  • Start date Start date
J

Jenna

How can I subtract the first row data to second row data
within a column, for example: I have this columns

Effective Date

5/1/04
5/3/04
5/4/03

I want to take the first row subtract to second row and
return the number of date between two rows, and continue
the operation taking the second row subtract to third row.
I don't that I can do such thing like this in Access or I
have to us Visual Basic Code? If I needs to use Visual
Basic, would you recommend any book or class that I can
take. Thanks

Jenna
 
You would need to use a subquery to get the value of the "second" row. But
you'll need to give us more info about the entire query's setup and the
tables from which you're drawing the records so that we could suggest a
query design.
 
Back
Top