I have a question for the list. I have gone into the archives and users
guide and have found one part of this question, but not the full solution. I
have a table of students with a column of INOUTDIST, and in the column there
is an "I" if they are varianced but from in district, and an "O" if they are
varianced but they are from out of the district. I have joined this table
to my school polygon service area table by school number to ultimately
thematically map the information. My dilemma is this: I can get a count
(frequency) of "I" and "O" and when I add schoolnum in there can get the
number by school. BUT I am still missing something - the query returns with
a TOTAL of "I"s and "O"s for each school. I can add in a where clause with
either "I" or "O", but cannot figure out how to get my query to breakdown
the number of each for each school. I know I could take this into Access and
manipulate it, but would like to keep it in MI with all of my MI pertinent
info if at all possible. Any and all suggestions greatly appreciated!
Thanks in advance.
Fran Peck
Office of Research and Planning
Peoria Unified School District
6330 W Thunderbird Rd
Glendale, AZ 85306
623-486-6099
Fax: 623-486-6111
Email: [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
