Results 1 to 2 of 2

Thread: creating a view

  1. #1
    Join Date
    May 2002
    Posts
    395

    Unanswered: creating a view

    I'm trying to create a view to check another view for a record that matches to the value in a textbox of a form. It is giving a syntax error.
    This is how my SQL looks like

    SELECT aql_level, aql_level_info
    FROM v_tblPart_cost_info
    WHERE cust_part_num = forms!edit_shiping_sched!cust_part_num

    Thanks!!

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    What was the error?
    Check books online for correct syntax=.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •