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