Hi guys,

I could have sworn I posted this thread already but I can't seem to find it. Sorry if this is a double post somehow.

I have a database which gets logged information every 5 minutes. I want to have a report that sums and displays the information every 15 minutes. So I would like information at 0,15,30,45 minutes. I wrote the if statement and it looks something like this:

if Minute({table.date}) <= 15 AND Minute({table.date}) >=5 then
   15
else if Minute({table.date}) <= 30 AND Minute({table.date}) >= 20 then
   30
else if Minute({table.date}) <= 45 AND Minute({table.date}) >= 35 then
   45
else if Minute({table.date}) = 50 OR Minute({table.date}) = 55 OR Minute({table.date}) = 0
   0

The above is what the group will be 'printed on any change of'. The number above are actually the date and time plus '15' or '30' as the minute display but it would be too long so I just put those.

I wanted to see 0,15,30,45 as the minute displays but now I'm seeing 15,30,45 and 55 as my displays. The sums are correct but the 55 is still displayed. I have a feeling this might be because 55 is the largest of 0,50 and 55 but I'm not sure? Does anyone have any suggestions?

mmmm.  ok. i'll take a closer look.