UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Syntax Question: Two Dates Needing Checked, Access 2010    
 
   
techexpressinc
post May 18 2017, 01:04 PM
Post#1



Posts: 316
Joined: 6-October 08
From: indiana, usa


I need to know what suspense set, an work-item is in; Suspense 1 thru 5.

So if First-Out Suspense-Date is populated and Second-to-Suspense-Date is not populated.
I need in the Indicator0to5 = 1

I attempted this query code and it failed, received a "#ERROR#" in the output.

Indicator0to5: IIf([CompFirstOutSuspense]<>"" And [CompSecondtoSuspenseDate]="",1,0)

Does anyone have a suggestion for the correct syntax?

Thanks
Russ

--------------------
Have a Great Day
Russ Neuman, FLMI, ASC
Certified MS-Office Specialist

Go to the top of the page
 
theDBguy
post May 18 2017, 01:12 PM
Post#2


Access Wiki and Forums Moderator
Posts: 69,936
Joined: 19-June 07
From: SunnySandyEggo


Hi Russ,

What are the data types of [CompFirstOutSuspense] and [CompSecondtoSuspenseDate]? If Date/Time, then you could try something like:

IIf(IsDate([CompFirstOutSuspense]) AND IsDate([CompSecondtoSuspenseDate]), 0, 1)

Hope it helps...

--------------------
Go to the top of the page
 
RAZMaddaz
post May 18 2017, 01:28 PM
Post#3


UtterAccess VIP
Posts: 9,387
Joined: 23-May 05
From: Bethesda, MD USA


PMFJI.....

Try using the following:

Expr1: IIf(Not IsNull([CompFirstOutSuspense]) And IsNull([CompSecondtoSuspenseDate]),0,1)

RAZMaddaz
Go to the top of the page
 
techexpressinc
post May 18 2017, 01:33 PM
Post#4



Posts: 316
Joined: 6-October 08
From: indiana, usa


Yes they are dates. I will try the formulas and let you how it goes.

--------------------
Have a Great Day
Russ Neuman, FLMI, ASC
Certified MS-Office Specialist

Go to the top of the page
 
techexpressinc
post May 19 2017, 08:45 AM
Post#5



Posts: 316
Joined: 6-October 08
From: indiana, usa


working thanks used ogre formula. Russ
Attached File(s)
Attached File  failed.JPG ( 33.41K )Number of downloads: 0
 

--------------------
Have a Great Day
Russ Neuman, FLMI, ASC
Certified MS-Office Specialist

Go to the top of the page
 
RAZMaddaz
post May 19 2017, 08:51 AM
Post#6


UtterAccess VIP
Posts: 9,387
Joined: 23-May 05
From: Bethesda, MD USA


Awesome!

yw.gif


Glad WE could help you!!!

RAZMaddaz
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    22nd June 2017 - 03:28 PM