Re: Counting days in a crosstab query

Tech-Archive recommends: Fix windows errors by optimizing your registry

Your question isn't real clear. The number of days betwee Jan 15 and March
23 is DateDiff("d",#1/15/2005#, #3/23/2005#).

I'm not sure what any of this has to do with a crosstab query.

--
Duane Hookom
MS Access MVP
--

"Scooter" <Scooter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7E66C4E0-BEB8-4C71-AD05-452717F64285@xxxxxxxxxxxxxxxx
>I need to count the number of days each month and quarter between two
>dates.
> For example Jan 15 and March 23. I need to count the total days for Jan,
> Feb and March. I'm having a terrible time trying to figure to the
> calculations.
>
> Any ideas?


.

Relevant Pages

  • Re: CROSSTAB QUERY: Combining text across columns
    ... >>Duane Hookom ... >>MS Access MVP ... >>> Subject: CROSSTAB QUERY: Combining text across ... >>> columns into one text string. ...
    (microsoft.public.access.reports)
  • Re: Months in column report
    ... > Also, the original query that was used to start the report, and still used ... >> of the crosstab query. ... >> Duane Hookom ... >> MS Access MVP ...
    (microsoft.public.access.reports)
  • Re: Matrix report
    ... >> Duane Hookom ... >> MS Access MVP ... >>> will lookup crosstab query but for other ideas here is a simplistic view ... >>> layout ...
    (microsoft.public.access.reports)
  • Re: Crosstab
    ... Duane Hookom ... MS Access MVP ... > I'm trying to rank the results of a crosstab query. ...
    (microsoft.public.access.queries)
  • Re: Creating multi Column Date Ranges using Now/Date ??
    ... Play with this SQL of a crosstab query: ... Duane Hookom ... >> MS Access MVP ... >>> there is an appt within the date ranges based on a now formula. ...
    (microsoft.public.access.gettingstarted)