query that presents quartly data without user interface

[rbellucci]

Ok, So I need a query that presents current quartly data live, It will be linked to a form so the user can see status open status of certain data. I've tried the date part function, datepart("q",Now()) which doesn't work so any ideas?




Thanks !

[rbellucci]

Disreguard Solved!

Year([Date])=Year(Now()) And DatePart("q",Date())=DatePart("q",Now())

[RuralGuy]

Thanks for posting back with your success and your solution.