| Olchi Pazmany |
|
|
Reply with quote | #1 |
I have to make a report, a labor "NO Time Reported" if during a week no date and associated worked hours has been in the data file. If minimum one day is reported, I can make the report, contains the missing days, but if NO any date with any hours entered in this time period, I have problem. I try to link the same table with != link, where Table 1 selected the "Time Reported" labors and Table 2 should give me the rest of the labors, but it doesn't work.
Any idea? Thanks Olchi
|
| |
| Alan |
|
|
Reply with quote | #2 |
You will need to create a calendar table that contains all the possible dates for your specific calendar. Using this table you will create a left outer join from this table to your other table that contains the hours. Join them by the date fields in each corresponding table. On the report use the date field from the calendar table and you will get the date no matter if you have data or not. |
| |
