Change order of groups 1

[netrusher]

Is there anyway to change the order of Groups after you create several of them for holding queries etc.?

 

[MallardVHS]

Hey Net,

I probably don't understand your question, but here goes:


Cant you 'click and drag' in the query (or group) box to rearrange the order?

I could swear that worked for me.


If this actually helps, buy lottery tickets.

don

[green]"They say that Fret A Stair was afraid of flights." I recommended a 12-step program.[/green]

 

[jedraw]

In the SQL used to cretae the groups, why not include an Order By clause.

 

[Golom]

Groups" (as in "GROUP BY f1, f2, f3, ...") don't have an ordering implication. A GROUP BY clause just says that SQL should create records where the concatenation of the fields in the GROUP BY clause is unique. Thus

GROUP BY F1, F2, F3
GROUP BY F2, F3, F1
GROUP BY F3, F1, F2
GROUP BY F2, F1, F3
etc.

Will produce exactly the same records.

If you want to see rows listed in a different order then use an Order by clause because

ORDER BY F1, F2, F3
ORDER BY F2, F3, F1
ORDER BY F3, F1, F2
ORDER BY F2, F1, F3
etc.

will produce (or at least may produce) different results.

 

[dhookom]

I think netrusher was referring to the under-appreciated ability/functionality of creating groups within the database window (nothing to do with SQL). You can store shortcuts to similar objects in these special groups.

I am not aware of a way to sort these groups.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[JerryKlmns]

How about ordering their names like

001 qwerty
002 abcde
003 zxy
004 b