Add a command button to a switchboard to open the expression builder

[Baron73]

I want to add a control to my switchboard that will open the expression builder so the users can build there own query. My db has 34 tables (one for each municipality in the county) and the query will search a date field for municipal actions by a date range. Can the CommonDialog control open the expression builder in a current db? Any help is greatly appreciated.<br><br>Baron73

 

[DougP]

No, but there is more than one way do anything.<br><br>Put ALL of you data from your 34 tables into one table and have a new field in that table that represents the table the original data came from.<br>so you have First name, last name, etc etc then the new field is called &quot;municipality&quot;.&nbsp;&nbsp;So if your old table called Tampa municipality has 100 reocrds in it then the new table has those same 10 records but the new field called &quot;municipality&quot; has &quot;Tampa&quot; in it for every one of thsoe 100 records.<br>When you've done that to all 34 tables then make a new 35th table and append the other 34 to it. This can be done with an update query and an append query.<br><br>When you are done you have one table with 10,000 records in it but each municipality can be found by a query that looks at the new &quot;municipality&quot; field.&nbsp;&nbsp;And then any other information that goes across municipalities can be gotten very easily cause you only have 1 table.&nbsp;&nbsp;You only add data to 1 table,&nbsp;&nbsp;your reports look at 1 table.<br><br>Maybe some of your tables have fields that other tables don't have. No problem you new big table has ALL of the fields that any separate table had. So some of the municipality records have blank fields which is perfectly normal.<br><br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.