Parameter Query

From: pjscott (pjscott_at_discussions.microsoft.com)
Date: 01/04/05

  • Next message: Hugo Kornelis: "Re: Parameter Query" 
    Date: Tue, 4 Jan 2005 06:47:03 -0800

    I'm using sql 2000 and Access 2002. I need to create a parameter query that
    would ask the following statement: "Enter the work order number".

    How would I do this in sql?

    Thanks for the help,

    Paul

  • Next message: Hugo Kornelis: "Re: Parameter Query"

    Relevant Pages

    • Re: 8i SQL Plus Edit Question
      ... So pasting 10 lines of 1000 characters each will work, ... >> accept more characters in an SQL statement than it does. ... SQL Plus won't let me paste the entirity of the long SQL into ... >> field in the work order table) or multiple locations (you would think ...
      (comp.databases.oracle.server)
    • Re: Syntax error
      ... > DATES in SQL statement must be in the format mm-dd-yyyy or the format ... > Paul wrote: ... >> Dim rs As New ADODB.Recordset 'Dim variables required in procedure ... >> Dim strSql As String ...
      (microsoft.public.access.modulesdaovba)
    • Re: SQL 6.5 sa Password, how to change?
      ... After changing it I can no longer connect to SQL ... > combination of letters, numbers, and symbol characters within the ... > and is not a dictionary word, command name, person's name, or system user ...
      (microsoft.public.sqlserver.security)
    • Re: DBIx::Simple variable interpolation problem
      ... "Thank you Paul" now? ... full working code snippet is below ... then run your queries multiple times. ... actual syntax of the SQL statement before it can be prepared. ...
      (comp.lang.perl.misc)
    • Re: Reporting dates from 2 tables
      ... The Parameters declaration will bring up a message box that prompts the user ... If it is indeed a parameter query you're after, then in the SQL view you can ... Then you can base your report on the query, so that every time the user ...
      (microsoft.public.access.gettingstarted)