Prev: Unmatched query
Next: postcode search, lookup, finder
From: RDE on 11 Jun 2005 16:45
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?
From: Duane Hookom on 11 Jun 2005 19:52
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.

--
Duane Hookom
MS Access MVP


"RDE" <RDE(a)discussions.microsoft.com> wrote in message
news:4500A617-3489-4913-9383-350B8F76FC9E(a)microsoft.com...
> 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?


From: Marshall Barton on 11 Jun 2005 21:24
RDE wrote:

>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?


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.

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: Unmatched query
Next: postcode search, lookup, finder