Search results for query: *

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...

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

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

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...

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...

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...