Need help sorting a query

Hello,

I have a combobox that is called "Category". This combobox runs a query that
has two fields "Category" and "Team" from a table.

I need to sort the query by Team first then by Category.

The problem is when I sort the query like the below it doesn't sort
correctly because I need the combox to populate the field with the Category
selection....

Category Team
No Sorting Ascending

When I run the query described above it sorts the Team fine however the
Category sorts all messed up.

Can you help with this problem and tell me how to correctly do this?



Thanks.
Iram/mcp

This combobox runs a query that has two fields "Category" and "Team" from a
table.
Post the query SQL by open in design view, click on VIEW - SQL View,
highlight all, copy, and paste in a post.

--
Build a little, test a little.


"Iram" wrote:

Hello,

I have a combobox that is called "Category". This combobox runs a query that
has two fields "Category" and "Team" from a table.

I need to sort the query by Team first then by Category.

The problem is when I sort the query like the below it doesn't sort
correctly because I need the combox to populate the field with the Category
selection....

Category Team
No Sorting Ascending

When I run the query described above it sorts the Team fine however the
Category sorts all messed up.

Can you help with this problem and tell me how to correctly do this?



Thanks.
Iram/mcp

Here you go....

SELECT tbl_Category.Category, tbl_Category.Classification,
tbl_Category.CountWhatCountsStat
FROM tbl_Category
ORDER BY tbl_Category.Classification, tbl_Category.CountWhatCountsStat;





"KARL DEWEY" wrote:

This combobox runs a query that has two fields "Category" and "Team" from a
table.
Post the query SQL by open in design view, click on VIEW - SQL View,
highlight all, copy, and paste in a post.

--
Build a little, test a little.


"Iram" wrote:

Hello,

I have a combobox that is called "Category". This combobox runs a query that
has two fields "Category" and "Team" from a table.

I need to sort the query by Team first then by Category.

The problem is when I sort the query like the below it doesn't sort
correctly because I need the combox to populate the field with the Category
selection....

Category Team
No Sorting Ascending

When I run the query described above it sorts the Team fine however the
Category sorts all messed up.

Can you help with this problem and tell me how to correctly do this?



Thanks.
Iram/mcp

Iram wrote:
Here you go....

SELECT tbl_Category.Category, tbl_Category.Classification,
tbl_Category.CountWhatCountsStat
FROM tbl_Category
ORDER BY tbl_Category.Classification, tbl_Category.CountWhatCountsStat;

I need to sort the query by Team first then by Category.

Then why not
ORDER BY tbl_category.Team, tbl_Category.Category

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201004/1