Creating a Report on the Fly Using a Form

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

Guest

I have a pretty difficult problem that has been plaguing me for quite some
time now. I am trying to create a report in which it takes information from
a form and creates a report using that information.

I have a database which has 13 tables. 1 table has Product ID#, and Product
Name, and the other 12 tables have test data for each of these products.
Each product can have different tests associated with it, and each test has
different fields of data. This data is organized by box number.

My problem comes when I try to create a report "on-the-fly" from all of this
data. I have a form set up with checkboxes (one for each test because my
reports do not need every test data associated with it), and I need to pass
that data on to report which filters in the tests I have checked. There is
no way I can create invisible headers for the columns on the report for each
test, because they will not fit. So what I need to do is have the report
create the headers itself and then fill in each test data I have selected.

Please Help!
 
This was similar to what I was looking for. However, I am trying to build a
query out of tables by using checkboxes instead of just selecting
fields....if that makes sense.

I already know which fields to include on the report, I just need to filter
the tables out.
 
The query by form is what it is. Feel free to modify it by creating a data
definition with a yes/no field for check boxes.
 
I tried using your applet, however when I select fields from more than one
query, it prompts me for the paramater value of the query that I do not have
selected. It only inputs those values of the query currently selected on the
query builder screen.
 
You need to create "master" datasource queries containing the tables you
want to query from. Name these master queries beginning with "<" so the
applet will recognize them.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reports that sift records from different tables 0
Access Sorting and grouping using multiple tables 0
Filter report by report 6
Changing report pages to separate Excel files 3
Cross tab vs. report 1
create multiple details in a report 1
How do I create a complex report? 1
Complex reporting task 6

Back
Top