I have to create a query and export to csv file. The application is an ins agent who has under him members for a website. The report will be weekly. The user wants to see all the new members under the agent from last Friday to the current Friday. The date when member joined is a field on the site. What would the query look like. Is there a way to automatically calcualte the date from the weekend before or will it have to been entered. Can the query to export be trigger weekly or does it have to be manually.