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.
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.