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

Combining Multiple Rows into One Form

P: 3
I work for an insurance company and what I'm doing is creating a database for writing policies where I can have one policy that covers multiple buildings. I have a form that they can fill out the insured's information and to add a building they just fill out another line of information on the same for with the same policy Number but just make it building 2 and so on... I have many querys which will calculate the final premium for each building. Giving me a Premiums Table:

Policy NO Building No Premium
AB1234 1 100
AB1234 2 250

What I need now is I'm making a form that will act as a bill. My problem is on that form I would like to place every building with the same policy number on one bill instead of having multiple bills for the same policy number. Is there any way to do this?
Mar 19 '12 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 15k+
P: 31,489
Yes. Design a query that links the Policy and Building data together. The bill could be produced from a report based on such a query.

I'm afraid your question is much too vague for more specific help. Please read the FAQ for what we expect you to include in a question.
Mar 19 '12 #2

P: 3
Lets see if i can be more specific,
I can have a table with one policy number and many buildings, when I'm building this form I can't figure how to place all of the buildings on one bill for the same policy number.

I guess I don't understand how to make a query that will create a form that will do what I want.

When I make many querys and forms off of those querys I still get two different records where what I need is a form that will combine all the records with the same Policy No into one.
Mar 20 '12 #3

Expert Mod 15k+
P: 31,489
I don't know about more specific. I see no information in post #3 that wasn't available in post #1. Certainly no table layouts; no SQL of queries; etc.

We can't work with nothing.
Mar 21 '12 #4

Post your reply

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