PULL DATA FROM EXISTING TABLES

[DIVINEDAR0956]

I have 5 tables that I need to pull data from. The common field among these table is the Project Number. How can I ask one table if the project number exist and have it pull the information from all 5 tables.

Can a query be done to ask for a certain project number and check all tables. If the information exist transfer the information from the storage tables to the edit tables in a different database.

A generic idea is all I'm looking for.

Thank you.

Darlene

 

[BVerlaan]

My impression is that your wishes ar too diverse to put it in one query. My advise: start programming. Create recordsets (i prefer ADO recordsets) and loop through the recordsets that you create. Decide what to do with a certain record, depending on the value of fields that you evaluate. If passed evaluation then add to table in other DB.
Is 'ProjectNumber' the only parameter you need te evaluate?

If you don't want to create VBA-code and the 5 tables are related to each other, perhaps you could create a parameter-query.
With a parameter-query you can add a criterium 'on the fly'.

I hope you understand what i mean. I use MS Office Pro Dutch. I've never seen the English terms.

I hope my comment inspires you.

Greeting, Bart Verlaan.