Re: making a "pattern table"

2004-11-23 Thread SGreen
What you are trying to make is called either a "pivot table" or a "crosstab report". There is a very simple pattern to writing one. I am assuming that all of the data is on just one table and that there can be one or more entries per person per program per month. I know these do not line up wit

making a "pattern table"

2004-11-22 Thread starr
Hi! I am wondering if there is a way using SQL to make a pattern file (I'm not sure exactly what to call it) of the sort following, which keeps track of people in programs of different kinds, by months of the year. A given file can be set up as below examining only 1 type of program (that is wha