Re: query that runs two variables
anonymous_at_discussions.microsoft.com
Date: 02/01/04
- Next message: Acie: "Query works perfectly on Query screen but Error on VBA ??"
- Previous message: John Vinson: "Re: Help please:-Passing parameters to a query from a module"
- Next in thread: Duane Hookom: "Re: query that runs two variables"
- Reply: Duane Hookom: "Re: query that runs two variables"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 31 Jan 2004 18:25:46 -0800
Thanks Duane. Un fortunately when I pasted your
suggestion into the query and modified the column headers
to match the table it gave me an error message that I was
missing a ! or .(dot) or illegal use of a parenthesis
message.
>-----Original Message-----
>Try:
>NumDays: DateDiff("d",[FirstDate], Nz([SecondDate],Date
()))
>
>--
>Duane Hookom
>MS Access MVP
>
>
>"Bruce" <anonymous@discussions.microsoft.com> wrote in
message
>news:707d01c3e6e8$0e816cb0$a501280a@phx.gbl...
>> I am trying to create a query that will give me the
>> difference between two dates in a number of days elapsed
>> format. That portaion works fine, but I also want the
>> same query to give me the elapsed days if the second
date
>> is missing, subsituting the current date.
>>
>> Something like:
>>
>> IF Date2 is Null
>> Then DateNow()
>>
>> any suggestions?
>
>
>.
>
- Next message: Acie: "Query works perfectly on Query screen but Error on VBA ??"
- Previous message: John Vinson: "Re: Help please:-Passing parameters to a query from a module"
- Next in thread: Duane Hookom: "Re: query that runs two variables"
- Reply: Duane Hookom: "Re: query that runs two variables"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
