Need help with SQL statement
January 26, 2011 7:13 AM Subscribe
I need to create a query in Access that shows the percentage of a total. I can't grasp the SQL statement I need.
posted by desjardins to Computers & Internet (7 answers total) 2 users marked this as a favorite
Let's say I have many companies, and each of those companies has a number of orders. Each company only has one location. I need something that shows the number of companies and % of orders completed at each location, like so:
Location | Number of Companies | Orders completed
Tokyo | 15 | 60%
Paris | 20 | 75%
Here is my db structure:
is a similar scenario but the SQL doesn't work (I get a syntax error on the join statement and I have spent an hour retyping it and searching for rogue commas).