- Joined
- Jul 15, 2008
- Messages
- 1
- Reaction score
- 0
Hi Everyone
I'm new to Access 2000 and I need some expert advise on query modifications
I've created a simple database with 1 single table called Table1, with 2 fields
username - contain username in text (eg. Bob Lee)
joindate - date joined in date/time format (eg. 11/07/2008)
I've create a select query called Query1 in Access. under SQL view it looks like below
SELECT Table1.username
FROM Table1
WHERE (((Table1.joindate) Between [FirstDate] And [End Date]));
This will prompt me to enter 2 dates and then display all the usernames joined between the 2 dates
Question 1. Is there a way where I can modify/create the query so it'll check the current system date and grab data for the last 7 days without prompting for date inputs
example, if I run the query on Monday 14/07/2008, it'll automatically check system date then grab data for last Monday to last Sunday (07/07/2008 to 13/07/2008).
Question 2. Once the data is shown in Access after the query run, is there a way that access can save the results (usernames) automatically to a plain text file called userlist.txt on C drive?
Thanks for your input and assistance
I'm new to Access 2000 and I need some expert advise on query modifications
I've created a simple database with 1 single table called Table1, with 2 fields
username - contain username in text (eg. Bob Lee)
joindate - date joined in date/time format (eg. 11/07/2008)
I've create a select query called Query1 in Access. under SQL view it looks like below
SELECT Table1.username
FROM Table1
WHERE (((Table1.joindate) Between [FirstDate] And [End Date]));
This will prompt me to enter 2 dates and then display all the usernames joined between the 2 dates
Question 1. Is there a way where I can modify/create the query so it'll check the current system date and grab data for the last 7 days without prompting for date inputs
example, if I run the query on Monday 14/07/2008, it'll automatically check system date then grab data for last Monday to last Sunday (07/07/2008 to 13/07/2008).
Question 2. Once the data is shown in Access after the query run, is there a way that access can save the results (usernames) automatically to a plain text file called userlist.txt on C drive?
Thanks for your input and assistance