Re: How do you calculate a null date?
- From: "Duane Hookom" <DuaneAtNoSpanHookomDotNet>
- Date: Mon, 30 Oct 2006 20:50:57 -0600
It isn't clear what you want for the calculation if the CheckOutDate is
null. You can use the Nz() function like:
Nights: Nz(CheckOutDate,Date()) - CheckInDate
--
Duane Hookom
MS Access MVP
"Rose" <Rose@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E422FD92-48F5-4436-AC62-347E2B64D567@xxxxxxxxxxxxxxxx
I am getting to many arguments when I try to input your information. Could
you try it again. I included an example below. Thank You.
Currently I have a query that states Nights:[CheckOutDate]-[CheckInDate].
The problem is if there is no checkout date yet, how can I get it to run
either today or by date input.
Check In Date Check Out Date Nights
09/01/2006 09/05/2006 4
09/10/2006 09/11/2006 1
09/12/2006
--
Rose
.
- Prev by Date: Re: Access 2003 Copy a record when a field contains two entries
- Next by Date: Re: Displaying the Difference Between a Date and Now()
- Previous by thread: URGENT - Need to match debits and credits
- Next by thread: Re: How do you calculate a null date?
- Index(es):
Relevant Pages
|
