Use Parameters In Queries And Reports

Topics:
Software tips
Tags:
Parameter
Source:
Microsoft

FREE Registration is required

Overview: When you want to restrict the data that you work with, based on the value contained in a field, you can use criteria in your query. When you want a query to prompt you for a value or pattern every time you run it, you can create a parameter query. You can also use parameters with a report to prompt you for criteria when you run the report. This paper explains how to use parameters in queries and reports, and how to use forms to enhance your use of parameters.

(Is this item miscategorized? Does it need more tags? Let us know.)

Format: HTML | Pages: 21


advertisement
  • Click Here
  • Click Here
  • Click Here

Returning users: Log In Here!

Already registered on BNET, TechRepublic, or ZDNet? Simply log in.

Free Membership: Sign Up Now!

Sign up for a free membership today and get instant and unlimited access to one of the largest databases of white papers, webcasts, and casestudies anywhere. Your FREE membership allows you to:

  • Download an unlimited amount of content, including classic and current white papers, case studies, webcasts and more
  • Track content on your chosen topics of interest
  • Receive targeted email alerts when your favorite content is added
  • Save content for future reading
  • Receive our member newsletter

When you register to access this directory, you become a member of BNET. In addition, you allow us to share your information with companies that produce products or services featured in the library--so that such companies may contact you with information and offers regarding their products and services. This enables us to keep the library a free service. As a directory registrant, you will receive a complimentary subscription to the BNET member newsletter, The BNET Report. You can unsubscribe from this newsletter at any time. By clicking the Sign up button, you indicate that you agree to our Terms and Conditions and have read and understand our Privacy Policy (updated).