Results 1 to 8 of 8

Thread: Parameter query? [Resolved]

Threaded View

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Feb 2003
    Location
    Argentina
    Posts
    1,950

    Parameter query? [Resolved]

    I've got a parameter query based on one table. The field names in the query don't match the field names in the table.
    VB Code:
    1. DELETE [Main].Hospital AS Expr1, [Main].Hospital AS Expr2, [Main].[Hospital] AS Expr3
    2. FROM Main
    3. WHERE ((([Main].[Hospital])<>[Which Hospital?]));
    Hospital isn't a field in Main. What's going on? The query apparently works when run in a DoCmd.OpenQuery statement.
    Last edited by salvelinus; Dec 10th, 2003 at 03:53 PM.

Posting Permissions

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



Click Here to Expand Forum to Full Width