Recent content by cbpwc01

Argh-- one problem. Now that I populate this, it is showing all products in the database no matter which client I am viewing on the form and not highlighting or indicating which products the client is in. This is my .sql: SELECT Products.Product, Client_Overview.Client_ID...

Thank you! I believe the first cut of the database is final, and I'll work more to get a better grip on the query function so that I can cut data in more ways.

I used the wizard to set it up and I now show both joins. However, my results list every product entry in the database--one product shows up 26 times instead of the products associated with one client ID showing up. I assume I'll use the query for the listbox. This is the SQL as I have it...

Thank you all for your help. The database is 85% of the way there and I am working on the first major form, which will be the main interface and data management place. All my fields work perfectly except the pesky products, which still displays only one product per client, not all the products...

To link the Products and RM/RM support, I made a Product_Overview Table: Product_OvID Product_ID RM_ID RM_SupportID I think the quarterly report information belongs here as well and added those accordingly. Am I wrong? Chris

I will add the numeric IDs and rearrange the tables as suggested, but I think I need the consultant_contact on the client_table as well since it is a contact specific to a client just like the "primary_contact" and "secondary_contact".. Answers to questions: Client_Visit(Schedule)...

Here is the full database structure. Primary Keys I denote with an *, Foreign keys I denote with a # For reference, Clients may or may not have a consultant contact, so they are a client field along with the primary and secondary contact. The products table I list a product and the services...

pwise, I keep getting the error "The number of columns in the two selected tables or queries of a union query do not match. (Error 3307)" This is the code as I entered it: Select 0,"Fund" from Products UNION select Fund from Products; Products is the table, Fund is the only field in the...

I am creating an Access 2003 database, and I haven’t built a database sine 2005 so my skills are very rusty. My main table is set up with the following fields: Client_Name Product Consultant Consultant_Name Primary_Contact Secondary_Contact Notes The field “Product” is set up as a lookup from...

I am working on designing a database at work and have the following tables: Main Table Article Name Publication Article Date Hyperlink to PDF Summary GP Client Topic Topic Table List of Topics I can categorize articles into Client List of...

I am running a report from a query of 50 individual datapoints, the results stacked vertically. I have set both the details section and each individual text box as "can shrink". Since the data is stacked vertically, the can shrink fundtion will not delete the labels. Is there a method to get...

I have a forms with two buttons linked to macros--one that put the form into "edit mode" and one that puts the form in "view mode". I want to have the button that is in effect to have the font appear a diiferent color. For example, when we are in edit mode, the text on the "edit mode" button is...

try eliminating any spaces in your table headings as sometimes access will not process them. for example, change [Data - Job Data] to [Data-JobData] Just a thought. Again, probably not the best solution.

You can also try this: Click the criteria cell under the field "industry". leaving the cursor in that cell, go to the top toolbar, click on query, and then click on SQL specific. Copy and paste the SQL codes from earlier in this post (adjusting names, etc), and hit enter. This is how I managed...

I have a complex form comprised of two subforms linked to queries, a data entry subform that links directly with a table, and a text box where users have to explain differences in the displayed results (the calculated allocations) and their entered allocations. I need to be able to print this...