Very simple syntax question
In advance forgive my ignorance - I'm developing in Access 2003....
I have a query that delivers an accurate dataset - Each church is submitting three proposals which are numbered with their church number (four digits) - their "first choice" has a "-1" after their church number. So church number "1101"'s first choice proposal is "1101-1". Each Church has 3 proposals (1101-1, 1101-2, 1101-3). There are 266 total churches. The proposals are picking other churches as part of the complete record. So each church can pick up to 6 other churches. But the "church of record" is the one at the top of the report. In other words, when I base the report on the query, if the report is about church "1101" I need the query to list Church 1101's 3 records at the top, to then be compared to the grouped (three) proposals from other church's that mentioned 1101 in their proposals.
RIght now the query works fine in that all of the records are accurately filtered into the dataset. So I have 1101's 3 proposals in the query results, along with all other churches that mentioned 1101 - no problem there. Here's where the question comes in. I'm going to give the user an input form to choose which report to run. So the user will pick "1101 St. Mary's" off of a combo box and hit the report button.
In SQL - how do I specify thatif the ParishID of the Church (chosen in the combobox) equals 1 to 3 parishID's in the dataset, that those three records should appear at the top of the dataset in ascending order (1101-1, 1101-2, 1101-3) - then the rest of the records should appear ascending by proposal number.
Thanks so much in advance. I didn't include field names or anything because I'm guessing it's some simple SQL standard syntax that I can adapt. I know how to do the runtime connect to the query using the combobox - I'm OK there....
OvernightGeek
