James, CHOOSE var_date FROM #VALUES FOR (CTXT(ch1_date)), (CTXT(COUNT(*) )) + FROM CHANGE1 WHERE CH1_SCHEDULE = 185 GROUP BY CH1_DATE
should do it - note the CTXT around the items in menu. If that doesn't give you the count that you expect try replacing the * with your column name: CHOOSE var_date FROM #VALUES FOR (CTXT(ch1_date)), (CTXT(COUNT(ch1_date) )) + FROM CHANGE1 WHERE CH1_SCHEDULE = 185 GROUP BY CH1_DATE Also, I am not sure that you need the Group By clause when the count works - but you may then need an Order By instead... Regards, Alastair. ----- Original Message ----- From: "James Hageman" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Friday, September 30, 2005 7:36 PM Subject: [RBG7-L] - Show a count(*) in a CHOOSE > I would like to use a CHOOSE to get distinct dates from a dataset and tell > me how many events are for a date in the CHOOSE is this possible. > > I want to take this select and put it in a CHOOSE command. > > SELECT ch1_date, COUNT(*) FROM CHANGE1 WHERE CH1_SCHEDULE = 185 GROUP BY > CH1_DATE > ch1_date COUNT (*) > ---------- ---------- > 05/03/1993 11 > 05/10/1994 6 > 05/04/1995 5 > 05/07/1996 2 > 01/31/1997 1 > 05/12/1997 6 > 01/06/1999 1 > 05/07/1999 6 > 02/24/2000 1 > 04/13/2000 12 > 07/10/2001 3 > 04/29/2002 1 > 04/21/2003 2 > 05/25/2005 1 > > > Something like : > > CHOOSE var_date FROM #VALUES FOR ch1_date, COUNT(*) FROM CHANGE1 + > WHERE CH1_SCHEDULE = 185 GROUP BY CH1_DATE > > ??? >
