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!
-
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: *
- Users: thomasrawley
- Order by date
-
Complicated Counting
So I got this to work in MS Access without a problem (I changed the date formatting to make it work of course). Now I just need to figure out how to make this work in Hyperion...which doesn't seem to be as flexible. SELECT AL1.STR_NBR, COUNT(AL1.CUST_ORD_NBR) FROM ( SELECT...- thomasrawley
- Post #4
- Forum: ANSI_SQL
-
Complicated Counting
Here is the SQL I have so far. This of course does not work but I think conveys what I am trying to accomplish. I am thinking I need a subquery somewhere in here but can't figure out where to do it...something that will limit the customer order numbers and then I can group and count in the...- thomasrawley
- Post #3
- Forum: ANSI_SQL
-
Complicated Counting
I am having trouble wrapping my head around this one. Here is the table of information I am working with. ORDERS Store# Order# Date 01 01 8/14 01 01 6/28 01 02 8/13 02 01 8/12 02 02 8/14 03 01 8/13 03 01...- thomasrawley
- Thread
- Replies: 3
- Forum: ANSI_SQL
