Why my report wont Sort?

[sondriven]

This is kinda a combo of a query and report question. I have a report built from a query that brings up four fields.

I having trouble with the query to sort. I have the first field [Product Name] set to Ascending. But when I run the query it doesnt sort to any one field. I have to manually hit the A-Z button.

So this problem rolls over into my report, where I hit the Sort/Group button and tried to sort the same thing but I get the same problem.

Are there any certain instances when a sort wont be performed?

Thanks for your help.

 

[simongallop]

Have you set the sorting up in the Sorting and Grouping bit (View / S & G)

 

[sondriven]

Yes, I tried that. I only need to sort by one field and i have that one in the first box and then set to Ascending.

 

[sondriven]

GOT IT! Gosh, that feels good. There were two fields named the same thing in my form and subform. The sort was to a Autonumber field when I was thinking it was going to another field.

Sort works great!