Please help with Access query

[jcdenton18]

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