Generic query

[hniessen]

I'm wondering if it is possible to design a generic query. So I have one query that can be used on several tables with the same properties but with different names. The query has to ask for the tablename on which it has to be performed.

Best Regards,
Hans

 

[braindead2]

here is an example

http://www.mvps.org/access/forms/frm0045.htm

or another example

Dim strSQL As String, tblname As String
tblname = Me!Combo6.Value
strSQL = "SELECT " & tblname & ".*, " from " & tblname

 

[THoey]

The first question I would ask is why you have "several tables with the same properties"? This is usually considered bad design. Why not have one table with a field that groups the data by region, department, whatever... Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[hniessen]

I know it is a bad design. It is my job to redesign this bad design.

Greatings,
Hans