teresamichele
Registered User.
- Local time
- Today, 00:19
- Joined
- Oct 18, 2010
- Messages
- 13
Hi all!
I created a database to track time entry for my group. Now we're at fiscal year end and I want to get a big huge Excel spreadsheet together for my boss but I'm encountering a problem.
I have some projects that are worked on every month, without fail. Others, we worked on for a month but then nothing else.
What I want to be able to do is run it so that it will list EVERY code and the hours worked for the month - even if the total hours is 0.
What it does NOW is lists everything for August...provided someone worked on the code that month.
Is there any possible way to modify my query to return ALL results - even if it's 0?
Thanks!
Teresa
I created a database to track time entry for my group. Now we're at fiscal year end and I want to get a big huge Excel spreadsheet together for my boss but I'm encountering a problem.
I have some projects that are worked on every month, without fail. Others, we worked on for a month but then nothing else.
What I want to be able to do is run it so that it will list EVERY code and the hours worked for the month - even if the total hours is 0.
What it does NOW is lists everything for August...provided someone worked on the code that month.
Is there any possible way to modify my query to return ALL results - even if it's 0?

Thanks!
Teresa