Generalize information through different access tables using VB co

[Guest]

I need to know if it is possible to create a VB-script to pull out
information from a huge access table to put the info. Into a generalize
table. Then from the generalized table pull out the exact information that I
want to view.
For example:
From the Main table that has many fields ----- I want to view TV’s
To general table----you pick out every field that deals with TV's
To a specific table ---- you want a TV that has AV inputs and outputs
for a VCR

If this is possible can you help assist me in creating and implementing the
code that I need to achieve this?

 

[John Nurick]

It's possible but not desirable. In general, the approach is simply to
write a query that returns the information you want from the "huge
table".

Without more knowing the structure of the table it's not possible to say
more.

By the way, when you say "VB-script" do you mean a VBScript script, a
VBA procedure (in Access? Excel? or what application) or a procedure in
a Visual Basic program?