User Profile

Collapse

Profile Sidebar

Collapse
jns42
jns42
Last Activity: Apr 18 '18, 01:25 PM
Joined: Apr 13 '18
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • jns42
    replied to How to join these 2 lines
    in Visual Basic .NET
    When you say "combine", what is your end-goal? Are you trying to issue a single statement cover both?

    If you have a collection of keys (e.g. "uniqueCode ", "strEmail", etc) to be read, then you could loop through that collection, issuing the call above once for each key. (In case you aren't aware, the List is in System.Collecti ons.Generic.)

    So, if you had something like this defined:
    Code:
    Dim
    ...
    See more | Go to post
    Last edited by jns42; Apr 18 '18, 01:11 PM. Reason: Additional information

      Leave a comment:

    • jns42
      replied to What is wrong with this statement
      in Access
      I'm not actually an Access expert, but in general T-SQL terms...

      It looks like you've also listed the source table twice - once before and once after the "FROM" clause. Try:

      Code:
      SELECT [ShipmentDetails-SelectPO].[Date Shipped] & " " & [ShipmentDetails-SelectPO].POID AS Expr1 FROM [ShipmentDetails-SelectPO] ORDER BY [ShipmentDetails-SelectPO].[PO]
      I've also removed the ending ';' character...
      See more | Go to post
      Last edited by twinnyfo; Apr 13 '18, 06:55 PM.

        Leave a comment:

      • jns42
        replied to What is wrong with this statement
        in Access
        You have an unnecessary ',' character before the "AS Expr1" statement.
        See more | Go to post
        Last edited by jns42; Apr 13 '18, 03:17 PM. Reason: Changed "extra" to "unnecessary"

          Leave a comment:

        No activity results to display
        Show More
        Working...