Ask Experts Questions for FREE Help !
Ask

Query Question for Access

Asked Jul 24, 2012, 01:33 PM — 3 Answers
Hello - I'm trying to create a field in my query that will do the following:
  1. Evaluate whether the Inactive Date field is either blank or has dates between: 7/1/12 and 7/31/12 and return the words "use for calculation"

The Inactive Date field in my table has blanks or sometimes it has dates. I'm concerned only with blank date fields and fields with dates that occur this month (July 2012).

I've been trying countless IIf formulas but I can't get it work correctly. I'm using Access 2000.

Thanks.

Search this Thread
Share |
3 Answers
ScottGem's Avatar
ScottGem Posts: 58,053, Reputation: 28125
Computer Expert and Renaissance Man
  
#2

Jul 24, 2012, 01:38 PM


CheckDate: IIF(IsNull(Inactive),"use for calculation",IIF(Inactive>=#7/1/12# AND Inactive<=#7/31/12#,"use for calculation",Don't use))

That should work.
Helpful
jakester's Avatar
jakester Posts: 554, Reputation: 826
Senior Member
  
#3

Jul 25, 2012, 06:31 AM
Quote:
Originally Posted by ScottGem View Post
CheckDate: IIF(IsNull(Inactive),"use for calculation",IIF(Inactive>=#7/1/12# AND Inactive<=#7/31/12#,"use for calculation",Don't use))

That should work.
Awesome...thx, man...got it to work
Helpful
ScottGem's Avatar
ScottGem Posts: 58,053, Reputation: 28125
Computer Expert and Renaissance Man
  
#4

Jul 25, 2012, 07:41 AM


welcome
Helpful
Not your question? Ask your question View similar questions
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Add your answer here.

Remove Text Formatting
 

Undo
Redo
  
Decrease Size
Increase Size
Bold
Italic
Underline
Align Left
Align Center
Align Right
Ordered List
Unordered List
Decrease Indent
Increase Indent
Insert Email Link
Wrap [QUOTE] tags around selected text
Wrap [CODE] tags around selected text
Wrap [HTML] tags around selected text
Wrap [PHP] tags around selected text
Wrap [YOUTUBE] tags around selected text
Notification Type:



Check out some similar questions!

Schedule for Access Query [ 1 Answers ]

Hi, I need to run some Access queries at midnight please help me in regards. I saw some articles related to MACRO but for them I must have to open the Access Database. Is there any thing like SQL Queries can be run from Command Prompt and we can make 1 cmd file to put in Windows schedule

Access Query Design [ 10 Answers ]

Hi all, I am new to the site and would appreciate any help. I have set of data I am having trouble with. I have one table which contains a series of

View more Access questions Search