Between Dates returning a value of Day

Question



I have a database for travel expenses. One of my tables is tblTrips. I have
created one field in the form for TripStartDate (using the MS Date & Time
Picker Control Version 6.0) and another field for TripEndDate (using the MS
Date & Time Picker Control Version 6.0). I need to calculate the expenses,
i.e., breakfast, lunch, dinner, cab, etc. for EACH day. I have a subform
with all the expenses for each day, but I need to generate a record for each
day in between the dates specified as TripStartDate and TripEndDate
automatically. Each trip will have a different amount of days. For example,
if the TripStartDate was 01/01/05 and the TripEndDate was 01/15/05, I need to
calculate the number of days between the days and then return a record, which
includes the daily expenses, for Jan. 1, Jan. 2, Jan. 3, etc. for example.

Thanks for any help.
--
S


Hi Sharon,

In Access Help find "Between"

HTH
--
-Larry-
--

"Sharon" <Sharon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message


I did look in the Help field under dates and between. I see how you can
choose how many "Sundays" occur in the time period of my between dates.
However, I want the values to List ALL days of my between dates. For
instance. If my start dates is May 5, 2005 and my end date is May 15, 2005,
the value that I want returned is:

Thursday 5
Friday 6
Saturday 7
Sunday 8
Monday 9
Tuesday 10
Wednesday 11
Thursday 12
Friday 13
Saturday 14
Sunday 15

Am I missing this somewhere? I have also looked under the MVP websites and
everywhere else I can think of. If you could be just a little bit more
specific I would appreciate it. Thanks.

--
S


"Larry Daugherty" wrote:

Click to show or hide original message or reply text.


> Hi Sharon,
>
> In Access Help find "Between"
>
> HTH
> --
> -Larry-
> --
>
> "Sharon" <Sharon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:4A9F17A7-5580-4F29-9C68-4E1B73B05DA6@xxxxxxxxxxxxxxxx
> > I have a database for travel expenses. One of my tables is
> tblTrips. I have
> > created one field in the form for TripStartDate (using the MS Date &
> Time
> > Picker Control Version 6.0) and another field for TripEndDate (using
> the MS
> > Date & Time Picker Control Version 6.0). I need to calculate the
> expenses,
> > i.e., breakfast, lunch, dinner, cab, etc. for EACH day. I have a
> subform
> > with all the expenses for each day, but I need to generate a record
> for each
> > day in between the dates specified as TripStartDate and TripEndDate
> > automatically. Each trip will have a different amount of days. For
> example,
> > if the TripStartDate was 01/01/05 and the TripEndDate was 01/15/05,
> I need to
> > calculate the number of days between the days and then return a
> record, which
> > includes the daily expenses, for Jan. 1, Jan. 2, Jan. 3, etc. for
> example.
> >
> > Thanks for any help.
> > --
> > S
>
>
>


--
S
.

Relevant Pages

  • Re: Unofficial poll of gas prices
    ... >> transportation thanks to higher fuel prices. ... job I am assigned to do, I expect, like all other employees, to have my ... travel expenses covered. ...
    (rec.scuba)
  • Re: Travel Expenses
    ... >meals, computer, etc). ... > My question is can I deduct all my travel expenses to and from my home ... Initially it sounds like your primary work location is going to be in the ...
    (misc.taxes)
  • Re: Between Dates returning a value of Day
    ... > I have a database for travel expenses. ... >Picker Control Version 6.0) and another field for TripEndDate (using the MS ... a table named Num, with one integer field N, filled with values from 0 ... Create a Query with your tblTrips and Num, ...
    (microsoft.public.access.formscoding)
  • Re: Serious question for WINNING poker players
    ... but I don't play high either. ... Probably 1/3 of the above is books and good chunk is travel expenses. ...
    (rec.gambling.poker)
  • Re: H1-B fees with employee personal checks? (to be reimbursed by employer)
    ... policy that asks employees to pay their expenses, ... for example - they reimburse travel expenses the ... This is completely different from stuff like travel expenses. ...
    (misc.immigration.usa)