The grid and resulting dyanset are shown in Figure 11. Table: Finances ID# Donation Table Finances Finances Sort Figure - Query 3A Show x x Criteria >0 OR To specify a greater than criteria, use the greater than operator followed by the value. The syntax does not include quotes when using a numerical type field. The following relational operators can be used in an Access query. Equal to: = Not equal to: <> Greater than: > Less than: < Greater than or equal to: >= Less than or to: <= Figure Query 3B Table: Members Relational operators also work equally as well on text Field Name Address fields. A criteria of < will result in all records where “m” Table Members Members the value in that field begins with the letters A through L. Sort This is illustrated on the Query 3B QBE grid in Figure 12. Show x x MS Access query criteria are not case sensitive; therefore Criteria < “m” M and m are treated identically. This is not the case for OR other DBMS software packages. Also notice the criteria, but not the relational operator, is enclosed in quotes. Criteria for text fields, unlike numerical fields, require quotation marks around the text. Another tool that can be used when writing a criterion on a text field is to use a wildcard. The * wildcard can be used to replace one or more characters. The ? wildcard can be used to replace a single character. Whenever a wildcard is included in a criterion the expression Like must precede the expression. Like - this tells the computer the criterion is anything that starts with a J no matter “J*” how many characters it has or what they are: Jay, Justice, Jo, would all meet the criteria
The grid and resulting dyanset are shown in Figure 11. Table: Finances ID# Donation Table Finances Finances Sort Show x x Criteria >0 OR Figure - Query 3A To specify a greater than criteria, use the greater than operator followed by the value. The syntax does not include quotes when using a numerical type field. The following relational operators can be used in an Access query. Equal to: = Not equal to: <> Greater than: > Less than: < Greater than or equal to: >= Less than or to: <= Query 3B Table: Members Field Name Address Table Members Members Sort Show x x Criteria < “m” OR Figure Relational operators also work equally as well on text fields. A criteria of < “m” will result in all records where the value in that field begins with the letters A through L. This is illustrated on the Query 3B QBE grid in Figure 12. MS Access query criteria are not case sensitive; therefore M and m are treated identically. This is not the case for other DBMS software packages. Also notice the criteria, but not the relational operator, is enclosed in quotes. Criteria for text fields, unlike numerical fields, require quotation marks around the text. Another tool that can be used when writing a criterion on a text field is to use a wildcard. The * wildcard can be used to replace one or more characters. The ? wildcard can be used to replace a single character. Whenever a wildcard is included in a criterion the expression Like must precede the expression. Like “J*” - this tells the computer the criterion is anything that starts with a J no matter how many characters it has or what they are: Jay, Justice, Jo, would all meet the criteria
Chapter%202-2.docx