Hour to pass as criterion in a query

[Frank Dulk]

I have a field in my table that is of the type it dates / hour.
I have a query where I pass the date as criterion, but also wanted the hour
to pass.

how do I make that?

 

[Rebecca Riordan]

Wrap the whole thing in # symbols:

#June 3, 1984 16:00pm#

HTH
--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

 

[Frank Dulk]

But the one that I want is to pass through fields the initial date and the
final date and through other field the final hour and the hour initial.

 

[Frank Dulk]

Like this:

I have a field in the table a field it dates / hour where is stored the date
and the hour and I want to do a query where I spend as criterion the hour.