Search results

Do you want to view the results of the parameter query before deciding whether to update the recordset, or do you want to automatically run the update? If you want to automatically run the update, you can specify criteria to select the records to update just as you specify records to display...

Try using an Update query. Add the field [qty on hand] to the design, and under "Update To" type [qty on hand]-[[qty checked out]-[qty checked in]]

I need to calculate counts for different variables from the same table, each with different criteria, and I'm wondering if this can be done in 1 query or if I need separate queries for each. Here's what I mean: I need the total number of people who completed an interview during a certain month...

It sounds like you need to use an update query. Open a new query in design view based on the table where the data is stored. Under Query in the menu bar, choose "Update Query". You can enter in selection criteria to determine which records to update, and there is a row for you to enter the new...

I would set the fields to a constant width - experiment to find one that is wide enough to contain the largest field you're likely to have. Use the line tool to draw one continuous horizontal line under all of the fields. For the vertical lines, you need to make sure that the only thing in the...

I'm trying to use a query to pull together information from several other queries. When I try to run it, I get the error message "cannot open any more databases". Any ideas why this happening (I assume there're too many subqueries?) and what the limit for open databases is? Thanks!

Thanks for the quick replies, everyone. I've been playing around with the db, and I think I've found a way to McGuyver what I need. If anyone's interested, the way I ended up doing it was to include the primary key in the individual queries, start the master query with the main table, add in...

Sorry, I think I mistakenly described the structure of a different query. Actually, all of the information I need is in one main table. Each record contains all of the information for one person. There are separate fields to record the date completed and status of each interview (e.g., int1date...

Hi, I'm new to the bb and I really hope someone can help me. My problem is similar to paulmconnel's posting from yesterday, but I don't know SQL so the responses didn't help me. I have multiple queries set up, each to pull information out of a different table (the total number of interviews...