excluding records if they appear on another table?

[Catherine B]

Hello, I'm new to the forum and relatively new to Access. There's something I'm trying to do but I'm not sure if it's even possible so I'm hoping someone can help me out and point me in the right direction

the situation:

I have one very big table containing data for around 250 petrol stations. The data is collected monthly, so each site has a record relating to each month. E.g site A has data for month 1, 2, 3 etc.

The problem is that in any month, some of this data needs to be excluded from analysis. And this will vary over the months. What I want to do is run a query where specific records are excluded, for example, exclude Site A data for month 1 and 3, Site B data for month 2 etc.

I have another table containing a list of which site + month data is bad and to be excluded. Ideally I want to simply add to the list each month before I run the select query.

the question:

Is there any way to exclude records from a select query based on their details appearing on another table?

help would be much appreciated!
thanks
Catherine

 

[Murli]

Hi Catherine,

I have attached a sample file for your reference.

Murli

 

[Catherine B]

Hi Murli,

thanks a lot that's great! Just what I needed. It will help me out with a few other problems as well

all the best
Catherine