Hour to pass as criterion in a query

  • Thread starter Thread starter Frank Dulk
  • Start date Start date
F

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?
 
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...
 
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.
 
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.
 
Back
Top