VB Code for Successive MS Access Queries

CONNOLE
03-26-2004, 02:48 PM
I am relatively new to coding so I hope you can bear with me.

I have recently completed all the necessary tables for a materials database on MS Access. Each property has its own table with a list of all the materials and their value for that property. However I am having a problem with queries. When i put through the first query I get all the materials which satisfy that query which is fine. However when I put through my second query I want it just to pick from materials which satisfied the first query.

Is there a VB code to do this?
i.e. each query can only select from what satisfied the previous query.

Any help would be really appreciated.

MKoslof
03-26-2004, 04:29 PM
Not really. There is no "build in" function to do this for you. You can write a query that handles all your conditions or use a nested SELECT query to return only results from a subset, etc.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum