Count unic days in report

[avaz]

Hi all
i need help to figuered out how to come up with the number of unic days worked
as the DB i atached if worker works in diferent work order in the same day in the report it comes up as he work two days
can any one help

Thanks in adavance

 

[Mihail]

While I steel use A2007 (and others, I am sure, A2003) it is not possible to open your DB.

 

[jdraw]

avaz,

You have Abel Helena Macaia working 13 hours in one day on the same Work Order, but a different Work Code. How many hours in your typical WorkDay?
What exactly are you trying to do in non Access terms--simple English?

 

[JHB]

Hi Mihail, haven't seen you for long time here, got a job?

 

[Mihail]

@JHB
Thank you because you still remember me.
Yes, I've got a job that "eat" all my time .
You ? How are you ?

 

[avaz]

Re: Count unique days in report

HI jdraw

Basically what I need is to run the report in a certain period of time and need to know how many days one worker worked during this period, I was advised to create a query but I can not pass this data to the report.
My knowledge access are very basic and I apologize for that, if you can give me further help i thank you very much.
I atached the DB with the new query

 

[jdraw]

@Mihail,
Glad you found a job.

 

[JHB]

When you look at the picture below, how do you want the result, (show a picture of that)?
How many days did the person work, (Days Total), we don't know how you count them, therefore you need to tell us what result you expected?

 

[avaz]

Thaks to all my problem is solved