Access%20-%20CH%206

Access%20-%20CH%206 - Click to edit Master subtitle style...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Click to edit Master subtitle style 11/28/07 Dr. K. Chen Dr. K. Chen 11 CIS 2640: Business Reporting Building Reports in MS Access CH 6 11/28/07 Dr. K. Chen Dr. K. Chen 22 Objectives l Conditional Analysis in MS Access l Parameter Queries l Functions that perform conditional tasks 11/28/07 Dr. K. Chen Parameter Queries l A parameter query is a query that asks you to enter criteria before the query is run. It is useful when you need to ask different questions using different criteria each time it is run. Dr. K. Chen 33 11/28/07 Dr. K. Chen Two Parameter Values Dr. K. Chen 44 11/28/07 Dr. K. Chen How to create a parameter query? 1. Create a SELECT query 2. Place square brackets ([ ]) around a parameter in the criteria row. Existing field names cannot be used as parameter. No periods, exclamation marks, square brackets or ampersands in your parameter either. 3. Run the query to see the Enter Parameter value dialog box Dr. K. Chen 55 11/28/07 Dr. K. Chen How does it work? (See p. 151) 1. Is the parameter in square brackets a field name? If it is, the field is used and there will be no prompting user for a parameter value. 2. Is the parameter a calculated field?...
View Full Document

Page1 / 22

Access%20-%20CH%206 - Click to edit Master subtitle style...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online