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 derfloh 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 RichMaine

  1. RichMaine

    Adding Times

    I solved the problem. I queried the Date/Time field. The minutes were stored as hours, and the seconds as minutes. I added up the hours (minutes) and the minutes (seconds) for the group. Then using the mod function (total minutes (seconds) mod 60), I obtained the number of seconds that were...
  2. RichMaine

    Database Location

    It is an MS Access 97 database. I tried adding an SQL expression, but System was not listed under the functions tree.
  3. RichMaine

    Database Location

    Is it possible (CR 8.5) to have the name of the database that is attached to a report print out on the report?
  4. RichMaine

    Adding Times

    I must have done something wrong, but I can't figure out what it is. Here is what I did and an example of the results. I created two formulas (one called Difference, and one called TotalTimes)The first one holds the first formula that you posted, and the second refererences the first but adds...
  5. RichMaine

    Adding Times

    I have an Access database that tracks my Music Collection. The time for each track is a Date/Time Field formatted to show only the time portion. I created a report in Crystal that groups songs by album. I tried to create a summary field that calculates the length of the album, but the sum...
  6. RichMaine

    Crosstabs

    I have a Crosstab report, and it doesn't print column heading for which te row has no data. In other words, say there are three rows 1,2, and 3 and 3 different data types A, B, and C. Row 1 has values for A, B, and C, Row 2 has B and C, and row 3 has A and C. What I get is: A B C 1...
See more

Part and Inventory Search

Back
Top