Hi all,

I've been poking around for a while but can't seem to find what I'm looking for.

I'm in the planning phase of a new application where I will fetch data from an Access Database and do some calculation.

The tricky part is that the users might want to exclude a dynamic amount of entries from one day to another.

Here's a simplified example:

VB Code:
  1. Cust_ID   Cust_Name  Package_No     Batch_No

  2. 1             Alice          1245            

  3. 2             John          B144            14

  4. 3             Eric           B145            13

  5. 1             Alice          1246            

  6. 1             Alice          1247            13

  7. 2             John           B146           

  8. .                .

  9. .                .


(The Batch_No field can be empty)

Now, Let's say that day 1 I want to exclude rows where Batch_No = 14 and Package_No = 1247 and 1245.

On day 2 I want to exclude rows where Batch_No = 15 and Package_No = B146 and 1247 and where Cust_ID = 1

Does anyone know where i might find examples, tutorials or just point me in the right direction on how to create the dynamic queries that make it possible to exclude the rows?