Access SQL get order and print it

[Signo.X]

based on the attached database, can any one please help me to construct an sql query that will return the following result from the tables in the DB?

OrderNo   Total OrderLines   Total Amount (of each order)
----------------------------------------------------------
1                 4 
4                 3

im really stuck!

Thanks in Advance ,,
~signo.X

 

[cjard]

If youre going to do some funky ascii art, please embed it in a code block

 

[Signo.X]

SQL Query problem!!

problem solved -

~signo.X