How do you calculate the difference between dates in adjacent records? The records are filtered by the way, so I can't use Dlookup because they do not have an autonumber-type ID.
For example, if we're calculating the number of days between listed Holidays - Christmas (25/12/2007) is followed by Boxing day(26/12/2007) and then comes the new year (1/1/2007). The daysBfrNxtHday column would show 1 (BD - Xmas) and 6 (Nyear - BD).
How do I calculate the "daysBfrNxtHday" field from either a form module or a query?
For example, if we're calculating the number of days between listed Holidays - Christmas (25/12/2007) is followed by Boxing day(26/12/2007) and then comes the new year (1/1/2007). The daysBfrNxtHday column would show 1 (BD - Xmas) and 6 (Nyear - BD).
How do I calculate the "daysBfrNxtHday" field from either a form module or a query?
Last edited:
