help in report

[Husean]

Dear all
I have a table that contains the Employee ID field and the date of the day of delay, hour and minute
Required in the report
1- Show employee number, delay days and total delay days
2. If the number of days is less than 3, it should not appear in the report
3 - If the number of days 4 or 5 days should only appear 3 days
4. If the number of days 6 appears in the report, this is very good
5. If the number of days 7 or 8 not included in the report shows only 6 restrictions

sample in the link

I am sorry for my English is not good
Thank you so much good

 

[Mike Lewis]

All sounds very straightforward. So what is your question?

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Olaf Doschke]

You have specified an exact mapping of real days and displayed days. So what hinders you to put this into a function or into lookup data, even if the math is over your head, you could simply store the pairs of numbers, there are only 9 pairs from 0-8 days. And there are only three sections or two turning points, which you could put into a table and then later even are able to adjust the specification.

Bye, Olaf.

Olaf Doschke Software Engineering

https://www.doschke.name