![]() For instance, in order to only return study subjects born between and, you could type the term “Between # And #”, into the criteria field under “Date of Birth. You can then use them in logical expressions Access supports. Dates need to be specified by surrounding them with “#” signs. Entering “>=20” (quotes not needed this time) in the Criteria field under “BMI”, would limit the results to just those participants. Using the same example, let’s say you wanted to limit your results to study subjects with a BMI over or equal to 20. If you are using a field in your query that stores numerical information, basic mathematical operators can be used to limit your results. To get back just the records where "Boston" was the response, you would type “Boston” (quotes included) into the "Criteria" field, and then run the query. For example, the third field of the Health Study example above ("City") contains all of the various cities subjects of the study come from. If one of the fields you are using is a text field, you can limit your results to those records containing a specific word or phrase by enclosing the phrase in quotes in the criteria field. While this requires a bit of knowledge of what expressions are useable in Access, there are a few easy ways to control what data you get back from your queries: ![]() By entering expressions in those fields you can limit the records your query returns to results that meet the criteria in your expressions. In order to get a smaller subset of those records, take a look at the “Criteria” row in the table at the bottom of the figure above.If you were to hit the “Run” button (towards the top left with the red exclamation point above it), you would get a list of just these fields from all the records in your table. Once you have made your selections you should have something like the figure below.(Note: you can also click and drag the field names to the table on the bottom.) Those fields will be entered into the table below. Once you have finished, you’ll be left with a screen like the one below (in which only one table has been selected.) Choose which fields you would like to include in your query results by double-clicking on the names in the box you see in the middle. ![]() Select the tables you want to use in your query by double-clicking on their names or highlighting them and clicking “Add.” You can select more than one table but they need to be related. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |