By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,029 Members | 1,290 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,029 IT Pros & Developers. It's quick & easy.

automatically insert sytem date and time to a query parameter

P: 1
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
Aug 6 '10 #1
Share this Question
Share on Google+
1 Reply


code green
Expert 100+
P: 1,726
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
Aug 6 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.