Search results for query: *

It works. Thanks. You just made a lot of people happy.

I need to run a report each month that gives me Fiscal YTD Totals. When I am setting up the report I only see the YTD is there some way to tell it Fiscal YTD and when the Fiscal Year starts (10/01/06)?

Great it worked.

I have a report I am running that list clients by their locality code. I have a parameter set up so the user can select the locality code they want to run the report for. Now the are asking to be able to select ALL and get everyone. How can I do this? Here is my record selection formula...

Thanks for the help it is working great now. Hope you have a Merry Christmas this was a gift for me.

Thanks that worked. But it has now presented another problem. When the time is a number such as 0930 it is leaving off the 0 on the front end so when it separates out the left two digits and multiplies by 60 it is multiplying 98 * 60 instead of 9. Also, once I have total all minutes at the...

visit.begin_time = 1440 Visit.end_time = 1506 Although the visit are showing up in a military time formart they are number fields. When you try to show the amount of time spent on the visit if you subtract one from the other you get 66 but it should be 26 minutes.

NNNN Military Time Informix Database 9.5

I am trying to convert a number field to a time field. In my database there is a visit.begin_time field and a visit.end_time field they are both number fields. I need to be able to get total time between the begin and end times in an HH:MM format for each visit then total time for each day...

It worked, thanks!!!!!!!!!!!!!!!

I am having a problem getting detail line info to show when one field is null. I am creating a report using fields from multiple tables. The main table is a visits table and another one is a visits mileage table. The second table holds the mileage that the person did when they made a visit to...