shaz0503
asked on
is it possible to have 'dynamic' reports using a template
All
I have several reports within a database that are replicated far 20 different areas with that area information only.
Is it possible to use a template and then through a 'function' get the reports for each area. main reason is that I currently have 80 reports (20 x 4 different report) and if I need to change something need to amend all 20.
Is not ot big a deal but if am able to use a template that just updates with 'function' would be easier
rgds
I have several reports within a database that are replicated far 20 different areas with that area information only.
Is it possible to use a template and then through a 'function' get the reports for each area. main reason is that I currently have 80 reports (20 x 4 different report) and if I need to change something need to amend all 20.
Is not ot big a deal but if am able to use a template that just updates with 'function' would be easier
rgds
Last Comment
ASKER
Thanks Capricorn1
Can you give me a bit more detail -
Can all these reports run off the one query? The Department Description field is what will determine the area report produced.
I have a seperate query that reports records using a 'between dates' query (pop up asks for date range'......is the principle here the same....
rgds
Can you give me a bit more detail -
Can all these reports run off the one query? The Department Description field is what will determine the area report produced.
I have a seperate query that reports records using a 'between dates' query (pop up asks for date range'......is the principle here the same....
rgds
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thanks Capricorn1
I hope to test this out this week..
rgds
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks
Have had a quick look and looks like something I can definately use....will have a play and let you know..
rgds
Have had a quick look and looks like something I can definately use....will have a play and let you know..
rgds
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
it will be better to use a form to set all the values for the different areas.