I am trying to look at this field {ENTER_TRANSPORT.RECEIVED}

and find all records with a timevalue of 07:00:00 to 18:59:59 to get a total of records for this shift.

Then all the records for 19:00:00 to 06:59:59 and get that total.

Any ideas?

Here is what I did try:
@DAY_SHIFT = TimeValue({ENTER_TRANSPORT.RECEIVED}) in TimeValue(07,00,00) to TimeValue(18,59,59)

@NIGHT_SHIFT = TimeValue({ENTER_TRANSPORT.RECEIVED}) IN TimeValue(19,00,00) TO TimeValue(23,59,59)
AND
TimeValue({ENTER_TRANSPORT.RECEIVED}) IN TimeValue(00,00,00) TO TimeValue(06,59,59)

Then do a count of these.

12/30/1899 07:00:00
or
07/01/2008 07:00:00