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 Mike Lewis 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: *

  1. Forest75

    Extract 2nd Max Date/Value

    Thank you everyone for your replies. Some excellent suggestions how to fix my current issue and more importantly some excellent tips on how to solve other queries.
  2. 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...
  3. Forest75

    Change data in a field based on certain criteria

    Brilliant, thats sorted it. Thanks very much. MS
  4. 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...
  5. Forest75

    Can I add a line of text to a blank report

    Hi Ian, Thanks very much, that is excatly what was required.
  6. 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.
  7. Forest75

    How do I display blank columns in a CrossTab?

    Thank you for your response. I think the 'mock crosstab' is the solution I will have to use for this one.
  8. 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