By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,041 Members | 1,793 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,041 IT Pros & Developers. It's quick & easy.

Generating report based on multiple user inputs.

jinalpatel
P: 68
I have two tables
Expand|Select|Wrap|Line Numbers
  1. MainFirm
  2. Name
  3. Address
  4. City
  5. State 
  6. Zip
  7. County
  8.  
  9.  
  10. Subfirm
  11. Companyname
  12. Address 
  13. City
  14. State
  15. Zip
  16. License year
  17.  
  18.  
I want to generate report that takes user inpput of subfirm!Comapnyname and subfirm!Licenseyear.
Results should be all mainfirm fields info and it should be grouped by County

What I did is I create a form for user input which has two textboxes called txtcompany and txtyear. One command button "Generate Report"

Also made one query that is parameterised and accepts inputs from this form.

Now what??
What should I do to link all of these and generate report from the form command button??
Please help..
Aug 12 '08 #1
Share this Question
Share on Google+
2 Replies


Expert Mod 2.5K+
P: 2,545
Hi. I do wish we could help you here, but your question really comes down to 'how do I implement everything else, starting from a few controls on a form', and really there is no way we can give more than general advice in answer to such a question. It also looks to some extent like a student project, and if it is you must understand that we cannot do your work for you, as our forum guidelines clearly state.

In general, then, you need to implement your tables properly and set 1-many relationships between the tables before you populate any of them. Design queries based on the underlying tables then base your forms and reports on those queries. It is an Access query which will accomplish the grouping you need, but we can't design it for you given that you have just two tables at present - your application is undoubtedly going to involve many more than that.

I recommend that you read any good introductory book on developing Access applications. I also recommend that you look at the sample Northwind database supplied with Access - it provides examples of main form / subform structures that may give you ideas on how to implement your database.

Good luck with your project.

-Stewart
Aug 12 '08 #2

jinalpatel
P: 68
Hi. I do wish we could help you here, but your question really comes down to 'how do I implement everything else, starting from a few controls on a form', and really there is no way we can give more than general advice in answer to such a question. It also looks to some extent like a student project, and if it is you must understand that we cannot do your work for you, as our forum guidelines clearly state.

In general, then, you need to implement your tables properly and set 1-many relationships between the tables before you populate any of them. Design queries based on the underlying tables then base your forms and reports on those queries. It is an Access query which will accomplish the grouping you need, but we can't design it for you given that you have just two tables at present - your application is undoubtedly going to involve many more than that.

I recommend that you read any good introductory book on developing Access applications. I also recommend that you look at the sample Northwind database supplied with Access - it provides examples of main form / subform structures that may give you ideas on how to implement your database.

Good luck with your project.

-Stewart
Thanks for your advise.
My tables, relationships,forms controls and report all were ready. The thing I had no idea was I don't know how to link them all. I read one book and read some of the same topics from interent and I get it worked.
Thanks for the help you do to the people like me via this forum..
Aug 13 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.