Re: FromDate - ToDate

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

sorry for the confusion everyone, below are a few more specifics.

I have a table called tblAvailability with three fields:

Property_ID
From_Date
To_Date

The from and two dates actually specify which days the property is avaiable.
FOr example:

Property_ID From_Date To_Date
Property1 1/15/2007 3/2/2007

This record specifies that Property1 is available from 1/15/2007 trhough
3/2/2007.

I would like to run a query that would group by property, by month, and sum
the number of days that property has available each month. In ths example,
the query would return:

Property_ID Month No_Days
Property1 January 17
Property1 February 28
Property1 March 2

Thanks again for any help you can provide.

Chad

"John W. Vinson" wrote:

On Wed, 26 Dec 2007 08:19:01 -0800, Chad <Chad@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

I have a table that contains a FromDate field and a ToDate field. Can anyone
help me determine the best way to develope a query (or set of quesries) that
will allow me to return the number of days, by month, that is included in
this table?

Thanks in advance,
Chad

What do you mean by "number of days, by month"? the number of days in January,
the number of days in February, and then the number of days in March as three
separate values, or what?


John W. Vinson [MVP]

.

Relevant Pages

  • Re: Rerun an open query in Access 2007
    ... Dan: I can't tell you specifics like that. ... Access to re-run the Query that is "on top". ... Quick Access Toolbar. ...
    (microsoft.public.access.queries)
  • Re: counting records in a recordset
    ... > I have a query that is supposed to return only 1 record, ... > record and alert the user to contact the database administrator. ... I cannot get into specifics because you did not ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.general)
  • Re: xlsatom, xprop
    ... More specifics, please. ... Do you want something like xset and xset q? ... Post the xprop command you're using. ...
    (comp.os.linux.x)
  • Re: Referencing a sum query result in a text box
    ... > It depends really on the specifics of what you mean. ... > If you have a query that produces totals according to groupings of your ... > probably include the totals query into the existing query that the form ...
    (microsoft.public.access.formscoding)
  • Re: Hiding dates Query fields
    ... "John W. Vinson" wrote: ... My query selects all the records that I want. ... John W. Vinson [MVP] ...
    (microsoft.public.access.gettingstarted)