User Profile

Collapse

Profile Sidebar

Collapse
B Edwards
B Edwards
Last Activity: Jun 27 '12, 02:41 PM
Joined: Jan 25 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • B Edwards
    replied to Access 2007 SQL Statement
    in Access
    I'm sorry. I made a typo. There is a WLPURCH in the PAYHST table and then WLPURC in the STATION table. Both are valid fields.

    I'm sorry, I'm new to updating queries in Access. Are you suggesting I just draw the join line between WLPURCH and WLPURC as well as the other four AND conditions? How about the SET condition? Just want to make sure I'm doing everything ok here.
    See more | Go to post

      Leave a comment:

    • B Edwards
      started a topic Access 2007 SQL Statement
      in Access

      Access 2007 SQL Statement

      Ok, So I have two tables. PAYHST1995 and STATION. What I want to do is find the value of the REVDCK column in the STATION table when the five conditions (PRDCDE is equal in both tables, WLDVOR is equal in both tables, etc.) When I find that REVDCK value in the STATION table, I want to dump that info into the STNREVDK field in the PAYHST table.

      I keep getting the error message of invalid syntax, you may have entered an operand without...
      See more | Go to post
      Last edited by NeoPa; Jan 25 '12, 11:18 PM. Reason: sp corrections + Fixed lack of [CODE] tags (and displayed SQL in readable format)
      No activity results to display
      Show More
      Working...