I’m sure this is silly for some of you, but I’m making the slow transition from the Access UI to writing SQL and I need help with the following concept.
I need to do calculations on data that looks like this: 4 distinct records with the same value in different periods:
Date Value
1/31/16 1,000
2/28/16 1,200
3/31/16 1,400
4/30/16 1,450
The SQL statement must calculate between the periods chosen, meaning query 1 may want to find the different between Jan and March (400), and query 2 may request the difference between Jan and April (450). The UI would have the start and end dates as parameters in the query.
Sorry for such a basic question, but once I get this concept a lot of other things fall into place.
I really appreciate the help. Thanks in advance.
I need to do calculations on data that looks like this: 4 distinct records with the same value in different periods:
Date Value
1/31/16 1,000
2/28/16 1,200
3/31/16 1,400
4/30/16 1,450
The SQL statement must calculate between the periods chosen, meaning query 1 may want to find the different between Jan and March (400), and query 2 may request the difference between Jan and April (450). The UI would have the start and end dates as parameters in the query.
Sorry for such a basic question, but once I get this concept a lot of other things fall into place.
I really appreciate the help. Thanks in advance.