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 Wanet Telecoms Ltd 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: *

  • Users: jimwarren
  • Content: Threads
  • Order by date
  1. jimwarren

    selecting records: "Or" won't work?

    i am trying to select all records that have an "order status " of "D", OR have a hold_reason of "DECLINED"... ie, ({sysoent.order_status} = "D") Or ({holdords.hold_reason} = "DECLINED") the only records returned from the above are the...
  2. jimwarren

    inserting a total for lastyearYTD?

    i have a report, grouped by customer type that has customertype, customer #, name, total of this year's sales(YTD) i want to add a column that is a summary of last year's sales for the same time period...ie, LastYearYTD.... is it possible to do that with insert - field object - and a new sql...
  3. jimwarren

    loop and movenext problem?

    Hi! I have a page that selects one or more "sourcecodes" from one table, then uses that recordset in another select .... the queries are working, but when there is more than one sourcecode, my output is just the last one repeated .... can anyone see what i might be doing wrong with...
  4. jimwarren

    add a single info line at end of detail section?

    i am using an invoice that lists the individual (lineitems) in a detail section... i want to add a single line after all the lineitems have been printed that says "FREE Report with every order" i added a formula in a new detail section directly below the lineitem detail section, and...

Part and Inventory Search

Back
Top