473,385 Members | 1,872 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

IIf statement question

20
Have a report query that identifies all program participants within a given month. Have a query that works well except that if the report is run after the beginning of new month, it includes enrollees in the new month, showing as negative numbers.
Since program participants often enroll prior to a given month or remain enrolled at the end of a given month, how do I structure the statement that would exclude those enrolling after a new month date, e.g.

IIf([EnrollDate]>=01/01/2011,????How do I say do not include these in the report?

Thanks for any help
Dec 26 '10 #1
1 1052
RuralGuy
375 Expert 256MB
IIf( [EnrollDate] < #01/01/2011#,,)
Dec 27 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Smriti Dev | last post by:
Hi there, I have the following code: echo "\n <address>"; if ($entry_info and $entry_info != '') { echo "\n ".stripslashes($entry_info).".,"; } if ($entry_info and $entry_info != '' ) {...
4
by: J Buchman | last post by:
I'm trying to write a statement in VB 6 that will give me the overtime pay. It needs to compute the first 40 hours at the normal pay rate, then any hours over 40 at rate * 1.5, then add those amount...
1
by: ron | last post by:
Hi, I'm still new at Python and have been away from programming for a number of years in general. I apologized in advance if this has been discussed extensively already. Is the input()...
0
by: Troy | last post by:
I forgot to add this question to my last post. Can someone help me out? Question: Say you have a drop down list based on a SQL statement, want limited by the values in another control on the...
21
by: Andy | last post by:
Can someone tell me if the following Switch...Case construct is valid? I'm wanting to check for multiple values in the Case statement without explicitly listing each values. So for example, will...
2
by: hype | last post by:
Hi, 1) If I need to monitor a resource eg, bufferpools at the database level across all users, how can I do this ? If snapshot monitoring needs to be done wouldn't enabling the switch at the DBM...
2
by: matthew custer | last post by:
In VB I can have a switch statement with a Case 1 to 5 in C# it seems I have to have Case 1: Case 2: Case 3: Case 4: Case 5:
5
by: | last post by:
is there anything like a SQL IN statement where x in ('123','456',789').... available in an IF statment in aspnet? I've got a number of possibilities for a session variable to be set equal...
2
by: Cathleen C via DotNetMonster.com | last post by:
I'm a semi-beginner with c# and am having a problem effectively implementing a switch statement. I've created an asp.net app that runs a report depending on which item was selected from a drop...
1
by: Matt | last post by:
I am writing a DELETE statement and I want to filter the records using another SELECT statement. My SELECT statement is a GROUP BY query that grabs all social security numbers from the "Data...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.