Fixed vs. Relative Time Periods

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RDE - 11 Jun 2005 21:45 GMT

An example of a fixed time period would be July 1, 2005 or Q1 2005, Q2 2005,
etc. Examples of relative time periods would be 12 month rolling to Current
Year, Current Year, Last Year, YTD Current Year, Current Quarter Current
Year, Previous Quarter, 12 month rolling two years ago, and so on.

Does access recognize the difference between fixed vs. relative time
periods? What would the best method be for creating relative time periods?

Reply to this Message

Duane Hookom - 12 Jun 2005 00:52 GMT

Dates are like numbers. Weeks, months, quarters, years, etc are like
counting by 5s or 10s or 25s. Relative dates are like subtracting numbers or
adding numbers.

Check the DateAdd() function or other date functions. You may need to be in
a module when bringing up Help.

Signature

Duane Hookom
MS Access MVP

> An example of a fixed time period would be July 1, 2005 or Q1 2005, Q2
> 2005,
[quoted text clipped - 6 lines]
> periods? What would the best method be for creating relative time
> periods?

Reply to this Message

Marshall Barton - 12 Jun 2005 02:23 GMT

>An example of a fixed time period would be July 1, 2005 or Q1 2005, Q2 2005,
>etc. Examples of relative time periods would be 12 month rolling to Current
[quoted text clipped - 3 lines]
>Does access recognize the difference between fixed vs. relative time
>periods? What would the best method be for creating relative time periods?

A date is a date. A time period is your interpretation of
multiple dates or a start date and a duration.

Check the DateSerial function in Help, you can do a lot to
specify a date relative to another date.

Also check the DateAdd function to addall kinds of durations
to a date.

Signature

Marsh
MVP [MS Access]

Reply to this Message