Recent content by FGL

Hi everyone! I would like to know if it is possible to create a roster in access 2007 that will be updated Automatically for each week of the month. Thank you!

Hi Simon b. Thanks for the reply. I did try it but it doesn't work. However you gave me the idea and when I tried this: from ((H t1 LEFT JOIN I t2 ON t1.HI = t2.HI) LEFT JOIN J t3 ON (t2.p=t3.p) AND (t2.ev=t3.ev)) worked fine. Thanks again

Hi everyone! I have a problem converting a mysql query to an access 2007 query. I am getting the "Syntax error in Join Operation" message. I can't make the join work correctly. Here is a generic format of the query select t1.HI,t1.name,sum(me) as Me from H t1 left join (I t2, J t3) on...