HI Again
anybody with any help to point me in the right direction?
Many Thanks
glen
glenfernandez
Last Activity: Dec 2 '08, 01:20 AM
Joined: Nov 12 '08
Location:
-
Hey Joe,
Sorry for the long reply before.
This is my problem:
BUT, my problem - and the user has stressed that this is ESSENTIAL - is:
When the user selects a department, two things should happen:
1) The department report is printed
2) Individual reports for all the MIS (Branch) belonging to that Department are printed as well.
Yes, what you had suggested initially should...Leave a comment:
-
HI Joe,
Thanks for looking through my code.
To explain my code, the first two strSQLs ("QryByMIS" and "QryByMISOP ") are being used to restrict the number of records I have to work with. QryByMIS pulls the relevant data from the (Monthly) Transactions table and QryByMISOP from the OP (Budget table).
The linked tables are there because:
1) The JOINS on tblMIS_Org, tblDepartment,...Leave a comment:
-
Hi Joe,
I will be sending you a PM in a bit.
Thanks
GlenLeave a comment:
-
HI Joe!
Thanks for the quick reply.
To answer your question, it would be set up such that if I choose to run a report for a department then the first report that shows would be the department totals. This should then be followed by multiple reports for each branch within that department. This means I would not have to cater for "printing departments by selected branches". I hope I have answered your question...Leave a comment:
-
Access Reports with SubReports
HI there,
Need a little help with the reporting component of my MS Access 2002 project and would appreciate any insight / help from the experts. Please bear with me as I am still learning Access and this is my first project using it.
I'm generating a financial reporting system for a bank and have created a form for user input to dynamically generate the financial reports. So far everything is coming along ok. The reporting... -
Hi Joe,
Just an update. Checked my indexing (figured it out after playing with the db) and indexed a few more fields.
Queries are running under 10secs now.
Your idea was brilliant and I learnt something invaluable. Thanks very much!
GlenLeave a comment:
-
HI Joe
Thank you for your kind reply.
I have tried your suggestions with the folowing outcomes:
1. Need to clarify that all the queries I am running are being done on the fly, using a form to dynamically pass the query parameters through. I tried doing the formatting in the 10 sub-queries, but I this formatting doesnt get pulled through to the main query. I even checked my table formats and the data...Leave a comment:
-
Speeding Up A Query
Hi All!
This is my first post although I have been visiting this forum for help with my Access development work. I have been tasked with preparing a Financial Reporting Tool using MS Access 2003 for a financial institution.
This is my first exposure to Access and VBA but I have gor a rudimentary model up and running. However, as I am running many queries in sequence the final report takes around 30 secs to generate....
No activity results to display
Leave a comment: