| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Group By in SQL
need to add a 'select' & 'Group by' statement in excel query.
The Spreadsheet looks like this KRE001 8/17/2007 KRE001 8/17/2007 WAT001 9/27/2007 WAT001 9/27/2007 TOT001 7/6/2007 KEM001 7/12/2007 CYC001 7/16/2007 CYC001 7/16/2007 MET007 7/16/2007 This is the sql statement. SELECT V_PO_HISTORY.VENDOR, V_PO_HISTORY.DATE_PO FROM V_PO_HISTORY V_PO_HISTORY WHERE (V_PO_HISTORY.DATE_PO{d '2007-07-01'}) I need to group the vendors in column A. can someone please help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
| I wish to group my worksheets under group tabs | Excel Worksheet Functions | |||
| How can I convert a group of numbers to a group of letters? | Excel Worksheet Functions | |||
| Taking age group Ie ages 20-29 and picking out net sales for group | Excel Worksheet Functions | |||
| How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions | |||
Threaded Mode
