how to join on all five tables from database, sorting them(eg. sort by 

"total" in descending order) and then display the result...please help 

me...thak you...

the best way..



open access.. make a new query selecting and sorting all the colomns you 

want and then click the "view-sql" option at the top.  this is the 

simplest way to do it, and access usually not wrong



> how to join on all five tables from database, sorting them(eg. sort by 

> "total" in descending order) and then display the result...please help 

> me...thak you...