form to print reports from

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to have a event to populate a table with all table names of
current db that I could us in a form to print a report from diffrent tables..
each table is just like the other one only the name is different..

Thanks for any help ..

Paul
 
This SQL will display the names of all the tables withinh the current db,
using the MSysObjects table

SELECT MSysObjects.Name
FROM MSysObjects
WHERE MSysObjects.Type=1
 
if you have multiple identical tables which are only differentiated by their
names, then it seems that you are storing data in the table names - which
breaks data normalization rules. suggest you combine all your data into one
table, with an additional field to store the data currently held in the
table names (months of the year, perhaps? productnames? whatever...). once
that's done it's easy enough to use a Totals query or SELECT DISTINCT query
as the RowSource for a listbox control in a form, so that the values in that
field are displayed. then you can write *one* report, filtering its' source
data by the value chosen in the form's listbox.

hth
 
Thank you for your responce..
These tables are a excell report sent daily and converted to a table in a
database.. to keep from making a new report each day I want to just change
table names on the report and print. There is too much data to just add to
one table.. I will keep looking for a simple way to update a query with all
the tables and print report from there..

Paul
 
Back
Top