Intelligent

Akpors Provokes His Teachers.

Akpors Asks teacher:
Excuse Ma,
Teacher: Yes Akpors.
Akpors: if you mix
Omo and klin, will there be
foam?
Teacher: Yes of course,
why ask such a silly question
at the beginning of a new Term
Are you going to pass this
class at all?
Akpors laughs and
whispers to the other kids,
Such a dumb teacher, how
can u get foam without adding water,
are we going to know anytin at all wit dis
teacher?! -

Examples of query criteria

Show All

When you want to limit the results of a query based on the values in a field, you use query criteria. A query criterion is an expression that Access compares to query field values to determine whether to include the record that contains each value. For example, = "Chicago" is an expression that Access can compare to values in a text field in a query. If the value for that field in a given record is "Chicago", Access includes the record in the query results.

This topic lists several examples of query criteria. It assumes that you are familiar with designing simple select queries.
To learn more about creating select queries, see the article Select data by using a query.

In this topic

• Introduction to query criteria
• Criteria for Text, Memo, and Hyperlink fields
• Criteria for Number, Currency, and AutoNumber fields
• Criteria for Date/Time fields
• Criteria for other fields

Introduction to query criteria

A criterion is similar to a formula — it is a string that may consist of field references, operators, and constants. Query criteria are also referred to as expressions in Microsoft Office Access 2007.
The following tables shows some sample criteria and explains how they work.

Criteria	Description
>25 and <50	This criterion applies to a Number field, such as Price or UnitsInStock. It includes only those records where the Price or UnitsInStock field contains a value greater than 25 and less than 50.
DateDiff ("yyyy", [BirthDate], Date()) > 30	This criterion applies to a Date/Time field, such as BirthDate. Only records where the number of years between a person's birthdate and today's date is greater than 30 are included in the query result.
Is Null	This criterion can be applied to any type of field to show records where the field value is null.

As you can see, criteria can look very different from each other, depending on the data type of the field to which they apply and your specific requirements. Some criteria are simple, and use basic operators and constants. Others are complex, and use functions, special operators, and include field references.
This topic lists several commonly used criteria by data type. If the examples given in this topic do not address your specific needs, you might need to write your own criteria. To do that, you must first familiarize yourself with the full list of functions, operators, special characters, and the syntax for expressions referring to fields and literals. For more information, see the articles listed in the See also section.
Here, you will see where and how you add the criteria. To add a criteria to a query, you must open the query in Design view. You then identify the fields for which you want to specify criteria. If the field is not already in the design grid, you add it by either dragging it from the query design window to the field grid, or by double-clicking the field (Double-clicking the field automatically adds it to the next empty column in the field grid.). Finally, you type the criteria in the Criteria row
Criteria that you specify for different fields in the Criteria row are combined by using the AND operator. In other words, the criteria specified in the City and BirthDate fields are interpreted like this:
City = "Chicago" AND BirthDate < DateAdd("yyyy", -40, Date())

---

 The City and BirthDate fields include criteria.

 Only records where the value of the City field is Chicago will satisfy this criterion.

 Only records of those who are at least 40 years old will satisfy this criterion.

 Only records that meet both criteria will be included in the result.

---

What if you want only one of these conditions to be met? In other words, if you have alternate criteria, how do you enter them?
If you have alternate criteria, or two sets of independent criteria where it is sufficient to satisfy one set, you use both the Criteria and the or rows in the design grid.

---

 The City criterion is specified in the Criteria row.

 The BirthDate criterion is specified in the or row.

---

Criteria specified in the Criteria and or rows are combined using the OR operator, as shown below:
City = "Chicago" OR BirthDate < DateAdd("yyyy", -40, Date())
If you need to specify more alternatives, use the rows below the or row.
Before you continue with the examples, note the following:

• If the criteria is temporary or changes often, you can filter the query result instead of frequently modifying the query criteria. A filter is a temporary criterion that changes the query result without altering the design of the query. For more information about filters, see the article Filter: Limit the number of records in a view.
• If the criteria fields don't change, but the values you are interested in do change frequently, you can create a parameter query. A parameter query prompts the user for field values, and then uses those values to create the query criteria. For more information about parameter queries, see the article Use parameters in queries and reports.

Criteria for Text, Memo, and Hyperlink fields

If you want to see a demo of criteria that you can use with text fields, see the article Watch this: Specify criteria for a text field.
The following examples are for the CountryRegion field in a query that is based on a table that stores contacts information. The criterion is specified in the Criteria row of the field in the design grid.

A criterion that you specify for a Hyperlink field is, by default, applied to the display text portion of the field value. To specify criteria for the destination Uniform Resource Locator (URL) portion of the value, use the HyperlinkPart expression. The syntax for this expression is as follows: HyperlinkPart([Table1].[Field1],1) = "http://www.microsoft.com/", where Table1 is the name of the table containing the hyperlink field, Field1 is the hyperlink field, and http://www.microsoft.com is the URL you want to match.

To include records that...	Use this criterion	Query result
Exactly match a value, such as China	"China"	Returns records where the CountryRegion field is set to China.
Do not match a value, such as Mexico	Not "Mexico"	Returns records where the CountryRegion field is set to a country/region other than Mexico.
Begin with the specified string, such as U	Like U*	Returns records for all countries/regions whose names start with "U", such as UK, USA, and so on.  Note   When used in an expression, the asterisk (*) represents any string of characters — it is also called a wildcard character. For a list of such characters, see the article Access wildcard character reference.
Do not begin with the specified string, such as U	Not Like U*	Returns records for all countries/regions whose names start with a character other than "U".
Contain the specified string, such as Korea	Like "*Korea*"	Returns records for all countries/regions that contain the string "Korea".
Do not contain the specified string, such as Korea	Not Like "*Korea*"	Returns records for all countries/regions that do not contain the string "Korea".
End with the specified string, such as "ina"	Like "*ina"	Returns records for all countries/regions whose names end in "ina", such as China and Argentina.
Do not end with the specified string, such as "ina"	Not Like "*ina"	Returns records for all countries/regions that do not end in "ina", such as China and Argentina.
Contain null (or missing) values	Is Null	Returns records where there is no value in the field.
Do not contain null values	Is Not Null	Returns records where the value is not missing in the field.
Contain zero-length strings	"" (a pair of quotes)	Returns records where the field is set to a blank (but not null) value. For example, records of sales made to another department might contain a blank value in the CountryRegion field.
Do not contain zero-length strings	Not ""	Returns records where the CountryRegion field has a nonblank value.
Contains null values or zero-length strings	"" Or Is Null	Returns records where there is either no value in the field, or the field is set to a blank value.
Is not empty or blank	Is Not Null And Not ""	Returns records where the CountryRegion field has a nonblank, non-null value.
Follow a value, such as Mexico, when sorted in alphabetical order	>= "Mexico"	Returns records of all countries/regions, beginning with Mexico and continuing through the end of the alphabet.
Fall within a specific range, such as A through D	Like "[A-D]*"	Returns records for countries/regions whose names start with the letters "A" through "D".
Match one of two values, such as USA or UK	"USA" Or "UK"	Returns records for USA and UK.
Contain one of the values in a list of values	In("France", "China", "Germany", "Japan")	Returns records for all countries/regions specified in the list.
Contain certain characters at a specific position in the field value	Right([CountryRegion], 1) = "y"	Returns records for all countries/regions where the last letter is "y".
Satisfy length requirements	Len([CountryRegion]) > 10	Returns records for countries/regions whose name is more than 10 characters long.
Match a specific pattern	Like "Chi??"	Returns records for countries/regions, such as China and Chile, whose names are five characters long and the first three characters are "Chi". Note   The characters ? and _, when used in an expression, represent a single character — these are also called wildcard characters. The character _ cannot be used in the same expression with the ? character, nor can it be used in an expression with the * wildcard character. You may use the wildcard character _ in an expression that also contains the % wildcard character.

Criteria for Number, Currency, and AutoNumber fields

The following examples are for the UnitPrice field in a query that is based on a table that stores products information. The criterion is specified in the Criteria row of the field in the query design grid.

To include records that...	Use this criterion	Query Result
Exactly match a value, such as 100	100	Returns records where the unit price of the product is $100.
Do not match a value, such as 1000	Not 1000	Returns records where the unit price of the product is not $1000.
Contain a value smaller than a value, such as 100	< 100 <= 100	Returns records where the unit price is less than $100 (<100). The second expression (<=100) displays records where the unit price is less than or equal to $100.
Contain a value larger than a value, such as 99.99	>99.99 >=99.99	Returns records where the unit price is greater than $99.99 (>99.99). The second expression displays records where the unit price is greater than or equal to $99.99.
Contain one of the two values, such as 20 or 25	20 or 25	Returns records where the unit price is either $20 or $25.
Contain a value that falls with a range of values	>49.99 and <99.99 -or- Between 50 and 100	Returns records where the unit price is between (but not including) $49.99 and $99.99.
Contain a value that falls outside a range	<50 or >100	Returns records where the unit price is not between $50 and $100.
Contain one of many specific values	In(20, 25, 30)	Returns records where the unit price is either $20, $25, or $30.
Contain a value that ends with the specified digits	Like "*4.99"	Returns records where the unit price ends with "4.99", such as $4.99, $14.99, $24.99, and so on.
Contain null null (or missing) values	Is Null	Returns records where no value is entered in the UnitPrice field.
Contain non-null values	Is Not Null	Returns records where the value is not missing in the UnitPrice field.

Criteria for Date/Time fields

The following examples are for the OrderDate field in a query based on a table that stores Orders information. The criterion is specified in the Criteria row of the field in the query design grid.

To include records that ...	Use this criterion	Query result
Exactly match a value, such as 2/2/2006	#2/2/2006#	Returns records of transactions that took place on Feb 2, 2006. Remember to surround date values with the # character so that Access can distinguish between date values and text strings.
Do not match a value, such as 2/2/2006	Not #2/2/2006#	Returns records of transactions that took place on a day other than Feb 2, 2006.
Contain values that fall before a certain date, such as 2/2/2006	< #2/2/2006#	Returns records of transactions that took place before Feb 2, 2006.To view transactions that took place on or before this date, use the <= operator instead of the < operator.
Contain values that fall after a certain date, such as 2/2/2006	> #2/2/2006#	Returns records of transactions that took place after Feb 2, 2006.To view transactions that took place on or after this date, use the >= operator instead of the > operator.
Contain values that fall within a date range	>#2/2/2006# and <#2/4/2006#	Returns records where the transactions took place between Feb 2, 2006 and Feb 4, 2006.You can also use the Between operator to filter for a range of values, including the end points. For example, Between #2/2/2006# and #2/4/2006# is the same as >=#2/2/2006# and <=#2/4/2006# .
Contain values that fall outside a range	<#2/2/2006# or >#2/4/2006#	Returns records where the transactions took place before Feb 2, 2006 or after Feb 4, 2006.
Contain one of two values, such as 2/2/2006 or 2/3/2006	#2/2/2006# or #2/3/2006#	Returns records of transactions that took place on either Feb 2, 2006 or Feb 3, 2006.
Contain one of many values	In (#2/1/2006#, #3/1/2006#, #4/1/2006#)	Returns records where the transactions took place on Feb 1, 2006, March 1, 2006, or April 1, 2006.
Contain a date that falls in a specific month (irrespective of year), such as December	DatePart("m", [SalesDate]) = 12	Returns records where the transactions took place in December of any year.
Contain a date that falls in a specific quarter (irrespective of year), such as the first quarter	DatePart("q", [SalesDate]) = 1	Returns records where the transactions took place in the first quarter of any year.
Contain today's date	Date()	Returns records of transactions that took place on the current day. If today's date is 2/2/2006, you see records where the OrderDate field is set to Feb 2, 2006.
Contain yesterday's date	Date()-1	Returns records of transactions that took place the day before the current day. If today's date is 2/2/2006, you see records for Feb 1, 2006.
Contain tomorrow's date	Date() + 1	Returns records of transactions that took place the day after the current day. If today's date is 2/2/2006, you see records for Feb 3, 2006.
Contain dates that fall during the current week	DatePart("ww", [SalesDate]) = DatePart("ww", Date()) and Year( [SalesDate]) = Year(Date())	Returns records of transactions that took place during the current week. A week starts on Sunday and ends on Saturday.
Contain dates that fell during the previous week	Year([SalesDate])* 53 + DatePart("ww", [SalesDate]) = Year(Date())* 53 + DatePart("ww", Date()) - 1	Returns records of transactions that took place during the last week. A week starts on Sunday and ends on Saturday.
Contain dates that fall during the following week	Year([SalesDate])* 53+DatePart("ww", [SalesDate]) = Year(Date())* 53+DatePart("ww", Date()) + 1	Returns records of transactions that will take place next week. A week starts on Sunday and ends on Saturday.
Contain a date that fell during the last 7 days	Between Date() and Date()-6	Returns records of transactions that took place during the last 7 days. If today's date is 2/2/2006, you see records for the period Jan 24, 2006 through Feb 2, 2006.
Contain a date that belongs to the current month	Year([SalesDate]) = Year(Now()) And Month([SalesDate]) = Month(Now())	Returns records for the current month. If today's date is 2/2/2006, you see records for Feb 2006.
Contain a date that belongs to the previous month	Year([SalesDate])* 12 + DatePart("m", [SalesDate]) = Year(Date())* 12 + DatePart("m", Date()) - 1	Returns records for the previous month. If today's date is 2/2/2006, you see records for Jan 2006.
Contain a date that belongs to the next month	Year([SalesDate])* 12 + DatePart("m", [SalesDate]) = Year(Date())* 12 + DatePart("m", Date()) + 1	Returns records for the next month. If today's date is 2/2/2006, you see records for Mar 2006.
Contain a date that fell during the last 30 or 31 days	Between Date( ) And DateAdd("M", -1, Date( ))	A month's worth of sales records. If today's date is 2/2/2006, you see records for the period Jan 2, 2006. to Feb 2, 2006
Contain a date that belongs to the current quarter	Year([SalesDate]) = Year(Now()) And DatePart("q", Date()) = DatePart("q", Now())	Returns records for the current quarter. If today's date is 2/2/2006, you see records for the first quarter of 2006.
Contain a date that belongs to the previous quarter	Year([SalesDate])*4+DatePart("q",[SalesDate]) = Year(Date())*4+DatePart("q",Date())- 1	Returns records for the previous quarter. If today's date is 2/2/2006, you see records for the last quarter of 2005.
Contain a date that belongs to the next quarter	Year([SalesDate])*4+DatePart("q",[SalesDate]) = Year(Date())*4+DatePart("q",Date())+1	Returns records for the next quarter. If today's date is 2/2/2006, you see records for the second quarter of 2006.
Contain a date that falls during the current year	Year([SalesDate]) = Year(Date())	Returns records for the current year. If today's date is 2/2/2006, you see records for the year 2006.
Contain a date that belongs to the previous year	Year([SalesDate]) = Year(Date()) - 1	Returns records of transactions that took place during the previous year. If today's date is 2/2/2006, you see records for the year 2005.
Contain a date that belongs to next year	Year([SalesDate]) = Year(Date()) + 1	Returns records of transactions with next year's date. If today's date is 2/2/2006, you see records for the year 2007.
Contain a date that falls between Jan 1 and today (year to date records)	Year([SalesDate]) = Year(Date()) and Month([SalesDate]) <= Month(Date()) and Day([SalesDate]) <= Day (Date())	Returns records of transactions with dates that fall between Jan 1 of the current year and today. If today's date is 2/2/2006, you see records for the period Jan 1, 2006 to to 2/2/2006.
Contain a date that occurred in the past	< Date()	Returns records of transactions that took place before today.
Contain a date that occurrs in the future	> Date()	Returns records of transactions that will take place after today.
Filter for null (or missing) values	Is Null	Returns records where the date of transaction is missing.
Filter for non-null values	Is Not Null	Returns records where the date of transaction is known.

Criteria for other fields

Yes/No fields   In the Criteria row, type Yes to include records where the check box is selected. Type No to include records where the check box is not selected.
Attachments   In the Criteria row, type Is Null to include records that do not contain any attachments. Type Is Not Null to include records that contain attachments.
Lookup fields   There are two types of Lookup fields: those that look up values in an existing data source (by using a foreign key), and those that are based on a list of values specified when the Lookup field is created.
Lookup fields that are based on a list of specified values are of the Text data type, and valid criteria are the same as for other text fields.
The criteria you can use in a Lookup field based on values from an existing datasource depend on the data type of the foreign key, rather than the data type of the data being looked up. For example, you may have a Lookup field that displays Employee Name, but uses a foreign key that is of the Number data type. Because the field stores a number instead of text, you use criteria that work for numbers; that is, >2.
If you do not know the data type of the foreign key, you can inspect the source table in Design view to determine the data types of the field. To do this:

1. Locate the source table in the Navigation Pane.
2. Open the table in Design view by either:
• Clicking the table, and then pressing CTRL+ENTER
• Right-clicking the table, and then clicking Design View.
3. The data type for each field is listed in the Data Type column of the table design grid.

Multivalued fields   Data in a multivalued field are stored as rows in a hidden table that Office Access 2007 creates and populates to represent the field. In query Design view, this is represented in the Field List by using an expandable field. To use criteria for a multivalued field, you supply criteria for a single row of the hidden table. To do this:

1. Create a query containing the multivalued field, and open it in Design view.
2. Expand the multivalued field by clicking the plus symbol (+) next to it — if the field is already expanded, this is a minus symbol (-). Just below the name of the field, you will see a field representing a single value of the multivalued field. This field will have the same name as the multivalued field, with the string .Value appended.
3. Drag the multivalued field and its single value field to separate columns in the design grid. If you want to see only the complete multivalue field in your results, clear the Show check box for the single value field.
4. Type your criteria in the Criteria row for the single value field, using criteria that is appropriate for whatever type of data the values represent.
5. Each value in the multivalued field will be individually evaluated using the criteria you supply. For example, you may have a multivalued field that stores a list of numbers. If you supply the criteria >5 AND <3, any record where there is at least one value greater than 5 and one value less than 3 will match.

How to Create Fondant Minions

So cute....Mrs Yobe and Son

Yobe's Family

Biafran volunteers carry rifle-sized

The Biafran war: Stern-faced Biafran volunteers carry rifle-sized sticks as they undergo three weeks of basic training at a military camp near Owerri, Aug. 1968. Arms for training are not available, and when these men are assigned to combat units they will receive uniforms and rifles. Image: Kurt Strumpf/Associated Press

I thought i shoul let you know

....I thought i should let you know

When I woke up this morning, I asked myself. “What is life about?” I found the answers in my room, The fan said be cool, The roof said aim high, The window said see the world, The clock said every minute is precious, The mirror said reflect before you act, The calender said be up to date, The door said push hard for your goal, The floor said kneel down and pray, And the phone said reach out and connect with others.

Teacher Accused Of Having Sex With Several Of Her Students

A teacher from the Grand Rapids Public School System in Michigan turned herself in to police Thursday night after being accused of having sex with her students, WZZM 13 reports.’

Jamila Love Williams, 35, was booked at the The Kent County Jail just before 6 p.m. She was charged with counts of third-degree criminal sexual conduct, all of which are felonies. No bond was set. More victims have come forward since Williams was charged, so the algebra teacher could face additional charges. Williams, a teacher at University Prep Academy for four years, was first accused of having s*x with two students.

The Kent County Prosecutor’s office authorized warrants for four counts of third degree criminal sexual conduct against the teacher. Allegedly, she sexually assaulted two boys–ages 15 and 16–at various locations in Grand Rapids over the past three months. After the police’s investigation into Williams’ conduct became public, more alleged victims have come forward. The prosecutor’s office is reviewing those cases.

Michigan Live reports that Williams has confessed to having sex with at least two boys. The 16-year-old victim says he had s*x with Williams at his home, a park, her car and other locations. The 15-year-old victim claims he and Williams had s*x in her car and even in an allay.

Williams has four children, ages 19, 13, 9, and 3, and twin step-children, age 16. She has been placed on administrative leave.

If convicted, Williams could face up to 15 years in prison.

Newone

Class of 2013 on ICT

Duty Call

My Primary Responsibility

Oppression of Woman

The original oppression of Woman was based on crude denigration. She caused Man to fall. So she became a scapegoat. No, not a scapegoat which might be blameless but a culprit richly deserving of whatever suffering Man chose thereafter to heap on her. That is Woman in the Book of Genesis. Out here, our ancestors, without the benefit of hearing about the old Testament, made the very same story differing only in local colour. At first the Sky was very close to the Earth. But every evening Woman cut off a piece of the Sky to put in her soup pot or, as in yet another rendering -- so prodigious is Man's inventiveness -- she wiped her kitchen hands on the Sky's face. Whatever the detail of Woman's provocation, the Sky finally moved away in anger, and God with it.

Well, that kind of candid chauvinism might be O. K. for the rugged taste of the Old Testament. The New Testament required a more enlightened, more refined, more loving even, strategy -- ostensibly, that is. So the idea came to Man to turn his spouse into the very Mother of God, to pick her up from right under his foot where she'd been since Creation and carry her reverently to a nice, corner pedestal. Up there, her feet completely off the ground, she will be just as irrelevant to the practical decisions of running the world as she was in her bad old days. The only difference is now that Man will suffer no guilt feelings; he can sit back and congratulate himself on his generosity and gentlemanliness.

Meanwhile our ancestors out here, unaware of the New Testament, were working out independently a parallel subterfuge of their own. Nneka, they said. Mother is supreme. Let us keep her in reserve until the ultimate crisis arrives and . . . Then, as the world crashes around Man's ears, Woman in her supremacy will descend and sweep the shards together. (89)

- Anthills of the Savannah

BAD OR GOOD?

A BAD ATTITUDE IS LIKE A FLAT TYRE, YOU CAN'T GO ANYWHERE UNTIL YOU CHANGE IT, YOUR ATTITUDE DETERMINES YOUR ALTITUDE, U SHUDN'T LOOK DOWN ON PEOPLE EXCEPT YOU LUVE THEIR SHOES OR YOU RAISING DEM UP ON THEIR FEET.*wink*

 

NIGERIA: THE CHANGE WE NEED

Assuming Sanusi is right, Gowon finished the joke Britain stated by creating 12 artificial states in an artificial nation they called Nigeria.
The government with 36 states which arose from equally artificial considerations instead of from resource oriented realities, have become unmanageable as productive and federating units. Federating unit means you give as well as take, not just a resource sucker or parasite tethered to the center by decree and corruption.
Assuming Nigeria does not divide as predicted: Most Nigerians would not want a return to 3 regions. But we identify with the
Geo-political zones.
So why not run Nigeria as six states, with 6 economies, governments and federating states with Abuja run as neutral metropolis funded from the contribution of the 6 states? Each state with its own police administration and municipal administration (aka local governments)
One problem the suggestion for state autonomy is facing is that most states are currently too small to run autonomous, self supporting
economies, e.g. for state police, etc.
They don’t have a sizable economy to financially support certain things without FG intervention. So what makes them a state? But each of these six states can have a large economy, easily:
1. Niger Delta State
2. Middle Belt state ( will exclude/include certain new areas)


3. South-Eastern ( or Biafra ) state
4. South-Western ( or Oduduwa ) state
5. North-Western ( or Dan Fodio ) state
6. North-Eastern ( or Kanem Borno or Boko Haram ) state
That is how those we are copying [USA] made sure the federating states can be autonomous and viable, in a voluntary union with a secession clause.
With this structure, the state decides how many local governments ( better called municipal councils ) it needs, then create and fund them itself with tax-revenue.

What Makes a Woman a Good Wife?

Life without Christ is full of Crises

http://www.click4laugh.com

Guest who?

Behold

vicjonaken@gmail.com

Type of God, How many?