Recent content by tehchino

Hi Doc_Man...hmm i tried to read up on datepart datediff and date add and work it out myself but i cant see how it relate to what i want...i cant see how it works. Can you explain it in more details please? Hi Raskew, hmm they wont have a field to specific yes or no if whether they are...

did your report inside have the colunm for OT? Is it that the report can be generated but that #error is shown instead?

you give me some time now think ah...

Errr..i know nuts about DateAdd, DateDiff, and DatePart functions. But i will go try to read it up myself tomorrow morning. Thanks and keep you update!

Oh i got this problem too before, i solved it by 'forcing' the Query to displace out the 2 coloum even i dont have any data. you try to set in the query properties( right click) under Column Heading and put in "OT", "Reg". It should work...

Hi there, i have a problem here, i posted this in some places too just in case.. I need to do up a report for generating Staff alertness The report is to show how much each team will get by the end of the month. If they meet the criteria to perform well, each member in that team will get $10...

Hi there, i have a problem here I need to do up a report for Staff alertness The report is to show how much each team will get by the end of the month. If they meet the criteria to perform well, each member in that team will get $10 for the 1st month(eg Oct). If the next month(eg Nov) they...

hi Fizzio, thanks for your willingness to help. I had solved my problem earlier on.But to answer to your qns, the scenario is that all staff come from different team and each team consist of 5-6 members. All the members in the same team is of same ranking and thus everyone is awarded. But if...

How to extract correct data?? Hi there, assume this scenario i have 4 table: tblAdverseRecord tblCompliment tblMC tblstaff They are are linked up by staff_no Each staff can hold a record for adverserecord, compliment or mc in diff table.. Now i need to do up one regconition report. Meaning i...