Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by willpp

  1. willpp

    calculating how old a client is from 2 dates

    Hi Is it possible to calculate how old a client is from the {CLIENT.Date of Birth} and when a client {REGISTER.Date of Registration} field Regards Paul
  2. willpp

    how do i add a date of >= to this formula

    thanks Madawc did not think to put the Bracket before the isull
  3. willpp

    how do i add a date of >= to this formula

    if isnull({CLCONT.Type}) or {CLCONT.Type} <> "UDES" then "" else {CLCONT.Type} something like this {CLCONT.Date of Contact} >= Date (2010, 02, 01) any help would Grateful PW
  4. willpp

    tying to show the client once even when the client has had multiple co

    Hi sorry what i am trying to to is if client has a 'UDES' CONTACT TYPE show clients and if client has not had this contact show as blank only problem at present when binging in the contact type field it shows all the contact that the client has had ie paul has had a 'UDES' CODE and also a...
  5. willpp

    tying to show the client once even when the client has had multiple co

    if isNull({CLCONT.Type}) THEN "UDES" ELSE 'BLANK' what i am trying to do is show clients that have not had a "UDES"({CLCONT.Type}) when i put paramiter of does not = UDES the reports shows all the other contacts that the client has had how do you show the client once
  6. willpp

    Grand total for times

    got this working and it puts all durations into Hour and minutes so this sorts the first part but then i want to add a grand total for hours and minutes any help would be grateful First part of formula local numbervar Hr := Truncate({ADCONT.Duration}/60); local numbervar Mn :=...
  7. willpp

    How do you change minutes into Hours

    at present it shows as 65 minutes duration but i would like it to show as 1 hour 5 minutes then add a grand total in hour and minutes I would be grateful for any help
See more

Part and Inventory Search

Back
Top