Question FTE - Headcounts

[lgatinoi]

Hi!

If someone is interested to help me about building an FTE/Headcounts reporting tool, you're warmely wellcome

I'm building an access database witch the following table

T_Category
T_Country
T_Departement
T_Function
T_FTE type
T_Analytical code 1
T_Year
T_Month

I've already the budget table and recordset, now where I have problem is how to structure the actual input in order to get the output (XLS file) by function by departement by country.

Thanks in advance for your tips!

LG

 

[John Big Booty]

What is the purpose of storing Year and Month is separate tables?

 

[lgatinoi]

What is the purpose of storing Year and Month is separate tables?

To get more facility to sort or fileter by month then by date in the report query according the month you are doing the reporting. It's a long way to do it and I'm sure there is a short cut

 

[John Big Booty]

If you store the full date (only) you can use the DatePart() function in your query to extract the Year and Month for sorting purposes.

 

[lgatinoi]

Thanks for the tips

How do you think I should do my input form according the result I want (the excel file posted)?

 

[lgatinoi]

I was in the idee to do a table for input of new headcounts/fte, A table for input of leaving, a table for input of ilnesses

But where i'm not comfortable I need a table to sum the actual... and to have an output like the excel file... Hope it helps somebody to understand where I'm going...

 

[John Big Booty]

You might find some guidance in this thread, read the comments made by both Bob Larson and myself.

 

[lgatinoi]

Hello

Here is the DB without sensitive data.

You can find what I'm trying to built for FTE reporting. Bob, already helped me on for deleting data from a list box...

Now I'm working on actual and need "to do" something like the excel file I've postes

 

[lgatinoi]

hello

here is the db without sensitive data.

You can find what i'm trying to built for fte reporting. Bob, already helped me on for deleting data from a list box...

Now i'm working on actual and need "to do" something like the excel file i've postes

.

.........................................................