Using parameters with queries and reports - Access - Microsoft Office Online - The Diigo Meta page

• 03 Sep 08
  

  davedubya

  access

• 07 Jul 08
  

  Claire

  database

  • The values you enter in the Query Parameters dialog box control two things: first, the order in which to display the parameters, and second, the data type to expect for each parameter. To populate the dialog box, enter the parameters in the order you want them to appear, being careful to enter the text exactly as it appears in the query design grid.
  • When you run your parameter query,  Access uses the data types you chose in the Query Parameters dialog box to validate the data that is entered. For instance, if you chose the Date/Time data type and entered 31-Feb-2004 (a date that could never occur), Access displays an error message that says, "The value you entered isn't valid for this field," and you'll have to re-enter the date. When you enter a parameter in the Query Parameters dialog box and don't specify a data type, Access converts the value entered into the Text data type.
• 03 Jun 08
  

  Thomas Christensen

  Access rapporter forespørgsler forms

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.