title: SQL Access Sentence
body: <p>I been trying to use this sentences that i made in SQL Server Management Studio, on access with no luck, after hours googling, i think they use different languages, can someone help me turn these in Access language?</p>
  
  <pre><code>select c.id_client 'Client ID',
  c.client_name 'First Name'
  c.client_lname 'Last Name'
  from client c join bills b
  on c.id_client = b.id_client join bill_detail d
  on d.bill_num=b.bill_num
  where month (b.date)=3
  and year(b.date)= year(getdate())
  group by c.id_client, c.client_name,c.client_lname
  having d.price &gt; (select avg(prirce) from bill_detail)
  
  
  select s.id_seller 'Seller ID',
  s.seller_name 'First Name',
  s.seller_lname 'Last Name',
  avg(quantity*d.price),
  from sellers s join bills b
  on v.id_seller=b.id_seller join bill_detail d
  on b.bill_num = d.bill_num
  group by s.id_seller, s.seller_name, s.seller_lname
  having avg (quantity*d.price) &lt; (select avg(quantity*d.price) from             
  bill_detail)
  
  select date 'Date',
  sum(quantity) 'Tickets Sold',
  sum(quantity*d.price) 'Total Amount Sold',
  avg(quantity*d.price) 'Average Amount Sold',
  from bills b join bill_detail d
  on b.bill_num = d.bill_num
  group by date
  </code></pre>
  
  <p>Sry, they were in spanish, hence the awfull english. And thanks in advance.</p>