automatically insert sytem date and time to a query parameter

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sadiadad
    New Member
    • Aug 2010
    • 1

    automatically insert sytem date and time to a query parameter

    hello,
    I am developing a database in Access 2003,
    some of my queries need current date and time for their processing. now i want my query to automatically take the system date and time and use it as a parameter to the reports i create from that query. Secondly, for each quarter i.e: 4 quarters of an year,it should display the related months of that quarter in the combo box on the form.
    please help me out solve these two problems
    thanx in advance
  • code green
    Recognized Expert Top Contributor
    • Mar 2007
    • 1726

    #2
    NOW() returns system datetime
    Date() returns system date.
    Time() returns the system time
    it should display the related months of that quarter
    What should?
    Surely this doesn't change Jan-Mar, Apr-Jun so use string constants

    Comment

    Working...