Search results for query: *

I am creating an auto dealer association member roster. My report is coming from two tables: Members and MemberContacts I want to list members and contact names as follows: [DealershipName] [Address] [City], [St] [Zip] Owner: [OwnerFN] [OwnerLN] Service Manager: [SvMgrFN][SvMgrLN]...

John: The only way your solution worked is if I only put "true" in the criteria for one manufacturer line. So if I have true under Ford and a dealer sells Fords Lincolns and Mercurys, thats fine. But then there are the dealers who sell only Chevrolets - they dont show up on the report. I need...

I am creating an association member roster of car dealerships. On the roster I want to list the lines (manufacturer)of cars the dealership sells. In my table I have each manufacturer listed as a yes/no field and if a dealer sells that line the box is checked for yes. Any given dealer might...

I made the table the report's recordsource and that got rid of all my error messages. Thanks

I see #Name? in several control fields in a form I am working on. I realize that this displays when there is no such field in the field list. The problem here is that the fields exist in the table that the form is based on but the fields are not on the field list in the form. I've checked...

What is the best table design to use when you have several different business categories (i.e. banks, insurance companies, manufacturers, charity foundations) and several different contacts at each company. Should I break the tables down into business categories and then further break them down...