Generating report based on multiple user inputs.

[jinalpatel]

I have two tables

MainFirm
Name
Address
City
State 
Zip
County


Subfirm
Companyname
Address 
City
State
Zip
License year

I want to generate report that takes user inpput of subfirm!Comapny name and subfirm!License year.
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..

[Stewart Ross]

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

[jinalpatel]

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,f orms 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..