Creating Relationships and Queries

[nacho]

Hello everyone,


First thread (Please tell me if you'd like Screenshots)

Edit: Problem solved, just changed the data-type so they both matched

New problem: I want to create queries showing a specific field and the field has many common values amongst the table
For example: The field has the entry "Nike shoes" 5 times "Adidas shoes" 3 times "Brookes" shoes 7 times.
I want to be able to sort these from the most common appearance to the lowest, so in descending order eg:
Brookes Shoes
Nike Shoes
Adidas Shoes
______
I understand that there is a "Sort" option, however this only puts them in alphabetical order.
Thanks

[ConneXionLost]

If you're absolutely certain that:

The customer's each have one salesman, ...

then, you should join your tables between "Customer's Salesman" in the CustomerDetails table, with EmployeeID in the SalesmanDetails table.

You may need to convert "Customer's Salesman" to the same type as "EmployeeID".

Cheers,

[nacho]

thanks conne

[TheShabz]

I dont know if your Edit was saying your "new problem" was solved, but in case its not...

SELECT myTable.ShoeName, Count(myTable.ShoeName) AS Count
FROM myTable
GROUP BY myTable.ShoeName
ORDER BY Count(myTable.ShoeName) DESC;

If you dont want to see the count, remove "Count(myTable.ShoeName) AS Count"

If that solved your issue, please mark thread "solved"

[nacho]

i finally figured it out, thanks anyways,