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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Forest75
  • Content: Threads
  • Order by date
  1. Forest75

    Extract 2nd Max Date/Value

    Hi, I have a current project which is causing me grief and need help please. I have a massive list of vehicle maintenance records containing multiple entries against registration numbers and what I need to do is find the latest odometer reading for each Reg. I have written the following query...
  2. Forest75

    Change data in a field based on certain criteria

    Hi, Using Crystal 2008 is it possible to change the data in a specific field based on data in other fields? If I haven't explained that well my example is this: Fleet No. Date Serv Type AM/PM 001115 28/09/11 AAA PM 001115 28/09/11 ABI PM 002120...
  3. Forest75

    Can I add a line of text to a blank report

    Hi all, If my report returns no data in the details section I need to print a line of text in the details sections to say "No Data Found". Is there an easy way of doing this? Many thanks.
  4. Forest75

    How do I display blank columns in a CrossTab?

    Although I have read a previous thread on this subject my query is slightly different in that I need to display all the columns between 2 dates in a CrossTab even the blank ones where the summarised field is a text string not a number. Can anyone help please?

Part and Inventory Search

Back
Top