I have attached a db here, ArnelGP had written it ... now for second project i need the module to change a bit,
Like everything is ok, but in Status field of QrytimeSheet i need module to look for Roasters table where field Hfrom is a date field for Holidays and same as Hto. I need to use these fields to mention holidays .. I have another field comments in Roasters table where i will mention the holidays name.
1- Now i want if the Days field in QryTimeSheet is falling between the field/Date Hfrom and Hto then in Status it should return the Comments text from the field Comments in Roaster Table
Else everything is ok..
Like everything is ok, but in Status field of QrytimeSheet i need module to look for Roasters table where field Hfrom is a date field for Holidays and same as Hto. I need to use these fields to mention holidays .. I have another field comments in Roasters table where i will mention the holidays name.
1- Now i want if the Days field in QryTimeSheet is falling between the field/Date Hfrom and Hto then in Status it should return the Comments text from the field Comments in Roaster Table
Else everything is ok..