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...

Thanks for the suggestion. Once I figure out the Access bracketing, maybe I can test it. Right now I can't get past the syntax errors. A couple of years ago I was used to the bracketing SQL in Access for SELECT statements, but I'm rusty now and have never worked much with UPDATE queries in...

Happy to share it: UPDATE [Table2] SET [Table2].Table1OldID = Table1.NewID WHERE ((([Table1.OldID=Table2.Table1OldID])<>False)); Let me know if you have question. Again, I get no syntax errors, just the error when I try to run the query. Thanks!

Thank you for your suggestion. It made sense to me and I was able to set up the query as an update query just fine with no syntax errors. However, I keep getting the following error message: Query1 is not a valid name. Make sure that it does not include invalid characters or punctuation and...

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...

Ah, its so simple. Thanks for that post. I changed those sum queries accordingly. As for the output of qry3, i just want one number, that is, the sum of qryBook2 and qryPopular2. I can probably figure that out, but i'm open to suggestions. thanks again for the help!

Its taken me awhile to respond. Sorry about that. The fields are in the same table. In the first queries, I have to count the data, since it is based on non-numeric entries. Then I'm able to SUM the counted data. I'll include the other queries below. There are quite a few of them, which is...

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...

Thanks for that feedback. I'll keep that bug in mind.

I'm assuming that you're using some type of user input in your query? It may be a matter of using wildcards in your search. In the query design view, under your fields for Status and Type, you could include this type of statement: Like [Enter the doc status:] & "*" and a similar statement...

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...

That's it! So simple that, of course I would overlook it. Sometimes I can't get used to the way Access complicates things. Thanks again!

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)...