Access Query Criteria Syntax

[Jagstrom]

field [calling dates] as long date

looking for help with syntax for Criteria: to return only [calling dates] matching today()

 

[TheAceMan1]

How are ya Jagstrom . . .

Try this:

[blue]   SELECT [Calling Date] FROM [TableName] WHERE [Calling Date] = Date()[/blue]

BTW: Welcome to [blue]Tek-Tips![/blue] Do have a look at one of the links at the bottom of my post. The links will help you [blue]ask better questions[/blue], get [blue]quick responses[/blue], [blue]better answers[/blue], and insite into [blue]etiquette[/blue] here in the forums. Again . . . Welcome to [blue]Tek-Tips![/blue] [blue]Its Worthy Reading![/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[PHV]

In the criteria field of [calling dates]:
=Date()

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886