I'm pretty new at writing SQL on Access and I need some help writing a
datediff query. Say I have a table called tb_Dates with the following
records:
A B C
1 02/01/05 02/15/05 02/25/05
2 02/02/05 01/31/05 02/15/05
3 02/05/05 -------- 02/16/05
4 02/05/05 02/18/05 --------
5 03/01/05 02/01/05 03/16/05
If A < B then calculated the difference in the number of days between B
and C.
If A > B then calculated the difference in the number of days between A
and C.
The result should be:
1 10
2 13
3 --
4 --
5 15
Any assistance would be greatful.
Edwin