If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subtract in the same field
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 |
#2
|
|||
|
|||
Subtract in the same field
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. -- Ken Snell MS ACCESS MVP "Jenna" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|