Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. renepaulin

    CONCAT in UPDATE query won't work

    Hi PHV, The & operator did the job, Thanks
  2. renepaulin

    CONCAT in UPDATE query won't work

    Hi, Can someone tell me why this won't work for me ? UPDATE Temp SET Field2 =('LEFT(Field2,'*-')' CONCAT '0' CONCAT 'RIGHT(Field2,' #')') WHERE Field2 LIKE '*- #'; I'm getting a syntax error on the SET line. Thanks,
  3. renepaulin

    ORDER BY a string numerically ?

    Hi all, Is it possible to order a query by a string but to order it numerically instead of alphabetically. I tried to convert the string to a number with no luck. Right now I am getting: 1,10,11,12,13,14,15,16,17,18,19,2,20,21 ... I want 1,2,3,4,5,6,7,8,9,10,11 ... Thanks Rene
  4. renepaulin

    Expected: expression ?

    Thanks PHV, it did help.
  5. renepaulin

    Expected: expression ?

    Hi all, Can someone help with this? I get an expected expression error. DoCmd.OpenReport cboReport.Column(1), acViewDesign Reports(cboReport.Column(1)).lblTitle.Caption = _ "string " & _ "string" & cboMonth & "/01/" & cboYear.Column(1) & "string" _ &...
  6. renepaulin

    unbound default value problem

    Hi all, I am trying to set a default value for a combo box that selects the year in order to print a report. I can't set it with the default value property in design view because the combo box is unbound. How could I do this ? Thanks Rene

Part and Inventory Search

Back
Top