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 gkittelson 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. 84vette

    I have a sql query that is not quit

    I guess what I was teying to accomplish is not possible since I don't wand to see the details (item_number) but just the totals of the vendors like below: PO PO MONTH YEAR COL1 ----------- ----------- ----------- 1 1999...
  2. 84vette

    I have a sql query that is not quit

    I ran the query you sugested and came up with an error message at the bottom, I use the month parm to some times select only month 03 thru 08 SQL QUERY MODIFIED LINE 1...
  3. 84vette

    I have a sql query that is not quit

    I have a sql query that is not quite right, I was trying to have the col1 field count the number of distinct po_vendor_codes under a distinct Item_part_number within the po_month and po_year ---- any suggestions .. SELECT PO_MONTH, PO_YEAR, COUNT(DISTINCT PO_VENDOR_CODE) FROM...

Part and Inventory Search

Back
Top