Search results for query: *

Thank you Michael, that seems to be the logical solution, to keep track of the record count for the group. I'll have to resort to the debugger!

Have been searching a while on this and other forums for a solution to this problem: I have a report that shows 79 rows of ranked data, only it all appears in the GroupFooter section. (Got rid of the Detail Section, for various reasons). I've been exploring forums to try and find a way and/or...

Thanks r937! That worked like a charm! Thanks to PHV as well, with a little modification (putting the column names in [] square brackets) that method worked as well, by putting the where clause in the "Criteria" section of the design view query dialog.

...and the problem is..... the table is an MS Access table, and it won't accept that syntax....I thought if I went into Sequel Specific/Data Definition dialog box where you can apparantly enter SQL, it would return what I was looking for....apparantly straight sequel doesn't work in access...

How does one create a query that will return a record set where the contents of one column is greater than the other? Table Name=SURVEY_RAW_DATA Column Name=TOTAL_EXP Column Name=TOTAL_NX There are obviously many more columns than those listed above in the table, but these are the two I want...