Search results

Thanks Brian that worked great. I know this is the query forum but if I wanted to drive it from a form how do you link the form to the criteria input of the query? Thanks again :)

I have a database with the following information: FTA # Date Attended Last name First name assigned person...... Each week I need to generate a report that shows the people that attended for that week, grouped by the assigned person. I only want to show the data for a specific "date...

figured it out I just figured it out. In the combo box properties I had the column count as 2. I should of had it as the number of columns in the query. It all works now. Thanks again.

Almost worked Thanks alot. It almost worked. When I select the head of the household in the combo box it updats the address automatically but not the other information. Here is the code below that I put in the Afterupdate field Private Sub Head_of_Household_AfterUpdate() Me.Address =...

I set up an Access database to track visiting families. Each person in a family is inserted as a seperate row in my table. The table has the following columns: Visitor # (which is an auto #), Head of household, last name, first name, phone, email, address and etc. The first person I enter when...

I set up an Access database to track visiting families. Each person in a family is inserted as a seperate row in my table. The table has the following columns: Head of household, last name, first name, phone, email, address and etc. I set up a quiery with a pull down menu in my form so when...