Search results

  1. B

    Report is retaining old data

    I created a report and everytime I run it, it brings back the old data instead of the new data from a new search. I did not realize that it was saved with the Save Data with Report option checked. I unchecked that option in the File drop down and also in the Options and saved the report again...
  2. B

    Pushing a value into a blank field on a report

    I am running a report that is sorted at two levels and totaled up at the second level. The problem I have is there are records where there is a value in the first group but blank in the second group. When the report is run, I get a blank in the column and the total next to it. I tried to...
  3. B

    Shading every other report line

    Been trying to figure out another way of doing this. I have use these two formulas before with no problems, but it doesn't seem to work on this circumstance. if RecordNumber mod 2>0 then crSilver else nocolor if RecordNumber Mod 2=0 then crSilver else NoColor The problem here is I am...
  4. B

    Sorting records for a specific date/time period

    Hi Kempes, This would actually work to as I would have to tweak it a little bit as the criteria has changed. Now they want a report for any records opened for the past year between the hours of 5:00PM to 7:00AM. With all the different time formula's to choose from, it got a little confusing...
  5. B

    Sorting records for a specific date/time period

    Thanks for the input Kempes. I am not sure yours would work as I am going from 5:00PM to 7:00AM the next morning. Thanks Racer25 for the suggestion. You turned on a lightbulb that I didn't see. It would be so much easier to use the inverse method and just filter out 7:00 - 5:00 on the same...
  6. B

    Sorting records for a specific date/time period

    Sorting it is easy, how do I do a report of just the records during the time span from 5:00PM - 7:00AM everyday
  7. B

    Sorting records for a specific date/time period

    I am trying to figure out how to sort daily records between the hours of 5:00PM - 7:00AM the folowing morning. It is easy to sort by days, but I am a little confused how to sort a specific time everyday, especially when it spans two days. Does anyone done this and can send me a copy of the...
Back
Top Bottom