Hi Again Nathan,
I wrote the expression wrong....when corrected,
returned dates....for most everyone. Some people don't have dates at all.
At 01:15 PM 2/22/2010, you wrote:
I wrote the expression wrong....when corrected,
returned dates....for most everyone. Some people don't have dates at all.
At 01:15 PM 2/22/2010, you wrote:
>[Non-text portions of this message have been removed]
>
>Have not tried this myself but I'd do a BAQ something like:
>
>for each EmpBasic no-lock , each LaborHed
>outer-join where ( LaborHed.ClockInDate <= TODAY
>+ 0 AND LaborHed.ClockInDate >= TODAY + -7) and
>(EmpBasic.Company = LaborHed.Company and
>EmpBasic.EmpID = LaborHed.EmployeeNum) no-lock.
>
>The outer join will tell you who has no records for a given day...
>
>Good luck,
>
>NB
>
>--- In
><mailto:vantage%40yahoogroups.com>vantage@yahoogroups.com,
>"Bob" <rcarlson@...> wrote:
> >
> > Using Vantage 803xxx and not having the
> payroll module has anyone developed a BAQ or
> Dashboard which could report Absenteeism?
> >
>
>