Confused - unique records query 1

[Moss100]

Hello,

I have a table called [works]

The table contains the following fields that I am interested in:

1. Date
2. CompanyName
3. Job
4. Amount
5. EmailAdd


The table has many records per day, often with 10 or more from the same Company . To be clear I have not set up the table, so do not want to alter it - the CompanyName is the unique id.

I need to be able to create a query which does the following:

1. Looks at all the records over the last 7 days
2. Shows the CompanyName if in those records (but only once - not repeated)
3. Shows the EmailAdd


Can I do this all in one query or do I need several queries?

Many thanks Mark

 

[SkipVought]

HI,

Select Distinct CompanyName, EmailAdd
From [works]
Where [Date] >= Date() - 7

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]