Hi
Have not sorted out the prob when i run it it just gives me 0.00 in return
{vrAttendance.AttendanceType} in ["Follow-up (Old)", "New Patient", "Rebook Patient"] and
{vrAttendance.SeenTime} in "09.00" to "16.00" and
{vrEpisode.Location} = "QEQM -THANET" and
{vrAttendance.AttendanceDate} in DateTime (2008, 06, 01, 00, 00, 00) to DateTime (2008, 06, 07, 00, 00, 00)
seentime & finishtime is string
Many Thanks For your Help