help need on query report on who is on leave

[islandboy]

hi guys,

i have a problem and i hope you can help me.
i am doing a project for my class and i have some difficulties completing the project.

1) i have a problem associating the leave with the employee
2)i need to calculate how many days that person took.


3)and if possible could a create a leave query that could search for one or all the personnel on leave?

thanks guys.

[RuralGuy]

This link may help you with part of your issues.

[islandboy]

This link may help you with part of your issues.

ok RG got the that part i used =DatePart("d",[DateTo])-DatePart("d",[DateFrom]), can you help me creating a query that will show who is on leave ?

thanks for your help mate.

[RuralGuy]

So you need the T-Leave records WHERE [DateFrom] >= Date() AND [DateTo] <= Date() Right?

[islandboy]

So you need the T-Leave records WHERE [DateFrom] >= Date() AND [DateTo] <= Date() Right?

what i need is a report that will show me who is on leave on that time when the report is created hope i make myself clear my friend. you think is possible to do?

[RuralGuy]

Did you understand the code I supplied? Try creating a query with what I supplied as criteria for the two fields.

[islandboy]

Did you understand the code I supplied? Try creating a query with what I supplied as criteria for the two fields.

ok mate i try that and let you know. thanks.

[RuralGuy]

I'll be around.

[islandboy]

i think i mess up....i think i need to explain to you what i need to do.

can you attach the form leave to the employee table such as if i look for an employee i can click on a button on the employee form and get the leave info.

hope you did understand me.

thanks.

[RuralGuy]

You need to populate your tables with some dummy data so tests can be run on what you want.

[islandboy]

You need to populate your tables with some dummy data so tests can be run on what you want.

i try entering data on the employee form but then i get error on T_Leave..

i tried to make it work no luck till now.