K
Karen
Hi,
I have created a calculated field in a query to display the results in a
particular order. What I would like to do now is to perform a query on the
results of this order using First of. This does not seem to be working in the
way I intend. While I am returning unique records, they are not being
returned in the order I would like. In the first query, after the sort order
is applied I have 416 records in my dataset where the survey=DL1. In my query
using first of, I should return all 416 of these records if it is working
correctly as each of these records is unique on the field I am grouping on.
I have created a calculated field in a query to display the results in a
particular order. What I would like to do now is to perform a query on the
results of this order using First of. This does not seem to be working in the
way I intend. While I am returning unique records, they are not being
returned in the order I would like. In the first query, after the sort order
is applied I have 416 records in my dataset where the survey=DL1. In my query
using first of, I should return all 416 of these records if it is working
correctly as each of these records is unique on the field I am grouping on.