Re: excel *** creation??

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 06/11/04 

Date: Fri, 11 Jun 2004 23:39:02 +0200

Hi
I still think you should add thise functionality in your database.
Otherwise you have to store all the information in Excel also.
So you either have to import specific date from your database into
Excel or go the other way around:
- add the information in yourdatabase
- create additional reports in Access 

--
Regards
Frank Kabel
Frankfurt, Germany
> Frank,
> Thanks for replying... we use a report generating tool (access)that
> gets talks to the database - but the custom reports don't have all
the
> information...
> I am creating this report for a manager -
> Basically - this is what she wants:
> employee: the project she is working on hours per month and YTD  -
all
> of these come from that report - but we need a rate we bill to each
> client per hour - which is determined by the total fee we invoice to
> each client...
> So what she would like for me to do if possible is a report/template
> where I get a drop down menu for each employee - then it would give
me
> the projects - the number of hours he/she have worked on monthly and
> YTD create a formula that pulls from another *** the amount
> invoiced/billed to client divided by the YTD hours worked on each
> project...
> Hope that helps...
> Again thanks for your time and help...
>
>
> ---
> Message posted from http://www.ExcelForum.com/