If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Subform - Data Display Problem

I have a form with a subform, the subform displays information based on a combobox selection of company. However, there are multiple records of many companies in the table with some of the records having different addresses.

I need the subform to only display unique/distinct records of the company based on the address.

...

Have a table with your company name, address, etc... Make the the data to your main form. the combobox should look up the record from this table by company name and the address and other info will pull up. For the subform, it needs to be based on a query where it matches the company name and address. All you need to do is use the following for your criteria in your query
[Forms]![Your Form Name]![Company Name] and under address do the same [Forms]![Your Form Name]![Address]

Hope this works.

You know, I'm sick of following my dreams, man. I'm just going to ask where they're going and hook up with 'em later

...

No apologies needed. We all start somewhere and I still don't know a 1/4 of some people know on here.

Onto the count query. when making a query there is a button on top with a Sigma (Greek letter that looks like an E). Click it and it will bring add a row to your query to sum, count, avg etc...Select count. Make sure to not display too many fields, the more fields, the greater the possiblity for each record to be unique and it will not remove any dups.

You know, I'm sick of following my dreams, man. I'm just going to ask where they're going and hook up with 'em later