tabledef or Querydef

[mtrack81]

In access 97, Can i use either tabledef or querydef in order to get a large group of records from different tables in my database and put them together? I have multiple tables where they have the same fields of equal type, and want to bunch the data for when i run a massive search on the records... i hope i was clear enough, any ideas please let me know.. thanks..

[Iouri]

Tabledef and Querydef are the collections which hold names of the tables and queries respectively.
If you need to get data from the similar tables you can use either UNION or JOIN

Iouri Boutchkine
iouri@hotsheet.com

[enigmaos]

you can use Querydef, which only looks for either pre-defined queries in Access or queries defined in your program, depending on where you point it to.
As for combining all the data together, try JOIN or UNION.

enigmaos@yahoo.com