Help on code By Shift

[rhurd]

I have a database called Picture. Picture.rtime is the amount of runtime and has to be /60. and is a charactor field. Picture.shift is numeric and has fields 1 through 6.
Picture.datestamp is datetime field. I am trying to do a fomula for each shift 1,2,3 for each day. Can someone show me how the fomula shoud read.

Thank You Dick

 

[LV]

Not sure whatyou mean by " I am trying to do a fomula for each shift 1,2,3 for each day.". Do yo need to create a report that will display Picture.rtime for shifts 1, 2, 3 by Picture.datestamp? Then the simpliest solution will be to group you report by Picture.shift, then by Picture.datestamp and display Picture.rtime in details section. Then add {Picture.shift} IN [1,2,3] into your record selection formula.