=> Display all entries where time is greater than 10:30am

R

Rhonda Fischer

Hello,

I have used the function hour in my query, but don't
know how to deal with minutes as well?

SELECT [OrderReceived].[OrderDateReceived], [OrderCodes].
[OrderCode], [OrderReceived].[OrderTimeReceived]
FROM (OrderCodes INNER JOIN OrderReceived ON [OrderCodes].
[OrderCodeID]=[OrderReceived].[OrderCodeID]) INNER JOIN
Suppliers ON [OrderReceived].[Supplier]=[Suppliers].
[Supplier]
WHERE ([OrderReceived].[OrderDateReceived]>=[Forms]!
[frmSupplierOrdersViewCRGtr10AMDateRange]![txtFromDate])
And ([OrderReceived].[OrderDateReceived]<=[Forms]!
[frmSupplierOrdersViewCRGtr10AMDateRange]![txtToDate]) And
([OrderCodes].[OrderCode] Like 'CR%') And (Hour
([OrderReceived].[OrderTimeReceived])>10) And ([Suppliers].
[Supermarkets]='Tesco')
ORDER BY [OrderReceived].[OrderDateReceived] DESC ,
[OrderReceived].[Supplier];


Do you have any helpful suggestion.

Thank you very much :)
Rhonda
 
D

Douglas J. Steele

One approach is (Format([OrderReceived].[OrderTimeReceived]), "hh:nn") >
"10:30")

Another is ((Hour([OrderReceived].[OrderTimeReceived])=10) AND
(Minute([OrderReceived].[OrderTimeReceived])>30)) OR
(Hour([OrderReceived].[OrderTimeReceived])>10)
 
Top