> Assume a Table contains 2 fields: Name and Phone. It appears that I can
> create a QueryDef to return the Phone field, given a name, such as:
> Parameter SelectName;
> Select
>     dbs.Phone,
> From dbs
> Where Name = SelectName;
> But instead of returning a field, can I get the position of an item in
> the querydef?

> Assume a Table contains 2 fields: Name and Phone. It appears that I
can
> create a QueryDef to return the Phone field, given a name, such as:

> Parameter SelectName;
> Select
> dbs.Phone,
> From dbs
> Where Name = SelectName;

> But instead of returning a field, can I get the position of an item in
> the querydef?

> Thanks for all information,
> G.Doucet

> I have a table with 20 records and a grid with 20 rows. The grid will not be bound;
> actually I was thinking of using the msFlexGrid. The table will hold at least 2 fields: a
> name and a group.I want the records on the grid in order of group, starting with the As,
> then Bs then Cs and so on. Here is an example of my grid with 3 columns, Name, Group and
> Result.
> (row)    name    Group    Result
> 1        cat    A
> 2        dog    A
> 3        horse    A
> 4        ant    B
> 5        fly    B
> I was thinking of doing a QueryDef with the OrderBy option to sort my data, and then fill
> the grid. But then, depending on what the user does, I may want to flag the word 'dog' by
> placing a word in the Result column of the row dog. But how can I know what row 'dog' will
> end up in from the querydef. It seems as though I will need to store that information in
> an array variable or something.