R
rjw24
I want to create a report from the information I have on a form. The database
is one I have inherited and poorly structured with one table and and 7-8
look-up tables. It looks at applications for dispensations and waivers. Each
application comes from a possible 7 different departments within the
business. The applications are processed and there are around 6 stages to the
processing. I have wrote queries that count the number of applications from
each department that are at a particular status of processing. There are
seven of these and I have created a form which is unbound but has 7 sub-forms
contained within it which all have their record source coming from 7 seperate
queries. The queries count the number of applications that are at a
particular status of processing.
I want to be able to take this information from this form and create a
report or transfer it to a template in excel for example.
I hope my explanation, which I am never very good at, is clear enough.
Thanks
is one I have inherited and poorly structured with one table and and 7-8
look-up tables. It looks at applications for dispensations and waivers. Each
application comes from a possible 7 different departments within the
business. The applications are processed and there are around 6 stages to the
processing. I have wrote queries that count the number of applications from
each department that are at a particular status of processing. There are
seven of these and I have created a form which is unbound but has 7 sub-forms
contained within it which all have their record source coming from 7 seperate
queries. The queries count the number of applications that are at a
particular status of processing.
I want to be able to take this information from this form and create a
report or transfer it to a template in excel for example.
I hope my explanation, which I am never very good at, is clear enough.
Thanks