M
mgkaam
I have a database that has 14 tables of different programs we use, each of
these table consists of the same fields but I need to keep them seperate
instead of putting them all in one table. All of the tables have a
relationship using a primary key named weekending date. Now my question is I
need to make a report out of all of these fields on one report, I have the
design but what I need is to have the report open up with a question so that
I can choose a weekending date, say from a drop down box and be able to pick
a what date to run and then return all of the totals from that weekending
date. I have done this a long time ago and just need a refresher.
these table consists of the same fields but I need to keep them seperate
instead of putting them all in one table. All of the tables have a
relationship using a primary key named weekending date. Now my question is I
need to make a report out of all of these fields on one report, I have the
design but what I need is to have the report open up with a question so that
I can choose a weekending date, say from a drop down box and be able to pick
a what date to run and then return all of the totals from that weekending
date. I have done this a long time ago and just need a refresher.