Search results for query: *

I am working with a form that includes a subform. The main form includes individual member information. The subform assigns the individual to a variety of committees. Within the subform, one field is a list box to select which committee(s) to assign the member to. The subform will be a...

I need a quick way to change the corresponding data in Table2 to new values that have come into existence for my Table1. With all that these tables have been through (see below if you want the whole story), the data value for my primary keys in each table was simply set for "number" instead of...

Hi Again, This is probably simple, but maybe not. I have some buttons on several forms that run some macros. These macros, in turn, run various update or append queries. While these macros and queries are running, I get several messages, something like "You are about to modify...

Hi, I'm trying to combine two separate fields into one SUM. Right now I'm taking one approach that works, though it seems to involve more steps than necessary. I'll call the fields Data1 and Data2. I have individual queries that count all of the instances of Data1 and Data2. Once the...

Hi, I have a query that calculates percentages for a group of employees, grouped by department. The goal was to have results that looked something like this: # Employees DEPT Percentage of Respondents 228 Operations 28.78 215 Corporate...

I am not sure how to title this question; I've found a way to do this, but I'm wondering if there's a better way. I've developed a database from a survey taken where I work. Many of the questions involved a drop down menu, ie. "How often do you order supplies?" with choices such as once a...

I'm trying to run an append query that will add multiple books to a single record. The single record comes from Table1, the records for books are located in Table2, and Table3 basically links Table1 and Table2 together. For the purposes of the query, I'm not using Table2 (the books table)...