Hi there,
Thank you for all the suggestions you have made, but believe it or not... Today my boss came in with the message the report is not needed anymore in this form. So I can quit trying to do this...
(Nevertheless, I am still curious how to do the things I wanted, but I won't bother you...
GJParker, I'll look into your solution. Although I am nog sure whether I can get the right view for this. But I can always try.
Thanx for the suggestion.
Lbass, I have tried it again (sanity check) but I really see lines where there is no new tool after a 'found a job' tool. I am curious what...
Hi and thanx for the solution.
I have tried it, but is has the same 'flaw' as my formula. The problem is that I don't want to see the clients which have a job and did not return to us.
That's why I think that on of the checks I need to do on the first supression (or not) if the next-next...
What is happening is the following:
I work for a department that tries to help people find a new job. We have different tools to do so (give course, help write letter etc.)
Each time we use a tool a new row is inserted in the database. There is 1 tool that is different from all the other tools...
More info. OK here we go. ohw, BTW I use CR 10.
What I have is four fields.
1) a Clientnumber ({TBLKLANT.KLAID})
2) a startdate ({TBLSELECTIE.SEEAFNAMEDATUM})
3) a text field (not in function)
4) a number field ({TBLUITSLAGSELECTIE.SELKLANTUITGESTROOMD})(1 means that something has changed in...
What I would like is to know if it is possible to ask not only the next in a cursor, but also the next/next value in a cursor.
Let me explain.
If I have three value in 3 different rows
row 1 contains a
row 2 contains b
row 3 contains a.
If values 1 and 3 are equal I want to show the value of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.