Search results

Thanks - after much back and forth it seems that it was user error. I am only a partial "user" in this scenario. ;)

In Access 2007, I have a form which contains the summary information of a store, and a subform which is intended to log records on employee hours for that store. The subform is supposed to display store employee names in a drop-down combo box using the store ID as a link. It's a straight link...

The stores have numerous roles associated. Taking off the criteria results in 500 records versus 106 that I'm looking for - the query returns all the stores plus each role associated. So I need the SQL to say, if role 1234 exists for this store, return the last name of the person in that...

Here is the generic SQL. SELECT [stores].*, [contacts].roleID, [contacts].lastname FROM stores LEFT OUTER JOIN contacts ON [stores].storeID = [contacts].storeID WHERE ((([contacts].roleID)=1234)) ORDER BY [stores].store; The three stores that are not appearing in the results have roles other...

Sorry - work got in the way of my replying. Now this report is due again so here I am. :) I have tried the outer join with no luck. When I do the outer join to list all stores and only list roles that have the ID criteria I enter, it does not return 3 stores that do not have that role...

I attempted to search on this question but couldn't figure out the right search terms. Sorry if it's a repeat - and if so just point me to the post with the answer. I am trying to figure out how to write a select query that accomodates the following situation. Suppose I have a table of...

Thank you for posting this solution... it worked for me too. :) This board is great. I don't really get why it works (don't " " imply text values?) but common sense tells me not to ask. So I'm going with it.

I have a report based off a query. The query includes a table field that is collected from a multilist on a form (e.g. check all that apply). The multilist is based off another table that includes an ID field and a value field (1 = value1, 2 = value2 etc). The form shows the multilist...

Duh. Thanks, that worked perfectly. :o

I just spent an hour searching on this and didn't see anything - sorry if it's a duplicate! I have a form and subform. The form has basic info related to a client, one field is "total volunteer hours required" (totreqhrs). The subform has individual records of each volunteer appointment...

This two-subform idea worked great and I added the other tip about setting the "allow additions" property to "no" in the second subform. It is a little clunky but it will work for my users just fine. THANKS! One follow-up question, though... When I open the form, it now opens displaying the...

Er... just realized I need a many-to-many middle table between the "family" table and the "events" table. But the basic question still applies - how to easily add records to this middle table?

Here's another question. I have two tables - one is a "family member" table and the other is an "events" table. The tables are linked one to many to allow tracking of which events are attended by which family members. I would like to be able to easily add records to the events table. My...

Hmmm... I will try the second subform idea. The first subform with all the records will get long with time so I don't want to turn off scrolling or make users go to the last record to enter a new one... I'll let you know if that works. Thanks for the suggestion.

Hi there! New to posting but have been helped immensely by other posts/responses. You guys rock. Anyway - I have two tables, a "person" table w/some basic demographic information (person_id is primary key), and a "contact" table (contact_id is primary key, table includes person_id field and...