I thought you were doing great with field names until I came to Date, Time. These are reserved words and should not be used - http://allenbrowne.com/AppIssueBadWord.html
Without seeing your problem query, I'd say you're making it more difficult to get what you want because you've separated Date and Time values. Access uses midnight where a time is not stored as part of the date value. This value is a double precision type number where left of the decimal represents the number of days, and to the right, the number of seconds elapsed since midnight December 31, 1899. You are probably trying to use the hours/minutes portion of a time value that has not been recorded for a given date in your table. It makes no sense to separate these values into two fields, since in order to use them with your required precision, you have to put them together as a value that represents a number like I just described. Again, since I can't see your query, there's an additional possible problem. If your query uses the BETWEEN operator, Access defaults the second date in this situation to midnight of the day before the specified date. In other words, if you say BETWEEN some date and 06/15/2017, you get no values that you'd expect at say, 2 minutes after midnight on the 15th. You have to use the DateAdd function to add the required number of minutes/seconds to the second date, or I believe, use <= and >= operators instead of BETWEEN.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.