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 Chris 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. jpercival

    Need SQL query to eliminate rows of a single table that net to zero

    Yes they will. I have tried some processing with the absolute value of quantity column but haven't been able to figure out how to specify which resulting rows I want deleted. ??? [ponder]
  2. jpercival

    Need SQL query to eliminate rows of a single table that net to zero

    Yes Mike, unfortunately I need xyz 12 abc 25 abc 25 Thanks anyway.
  3. jpercival

    Need SQL query to eliminate rows of a single table that net to zero

    I have a single table with items and quantities as follows: Items Quantity xyz -12 xyz 12 xyz -12 xyz 12 xyz 12 abc -25 abc -25 abc 25 abc 25 abc 25 abc...
  4. jpercival

    Access/SQL function like Oracle's substr ?

    Thanks so much...they are just what I've been looking for!
  5. jpercival

    Access/SQL function like Oracle's substr ?

    Can anyone tell me if there is an Access SQL function similar to Oracle's substr? If I wanted to pull the first three characters of a name field from an Oracle table I would code: Select substr(name,1,3) from mytable; What would the Access equivalent to this be? Thanks in advance for any help!

Part and Inventory Search

Back
Top