Search results

I did that but it's called Family in the Family and People tables. I think this is just semantics.

This is the latest db with the Family table.

The Family field ties the spouses, along with their children, together at the same address so they don't get mixed. Two families with the same last name and different addresses would have separate AddressIDs. Since children aren't listed in the directory, it's a moot point if Beth Jones is...

In the Directory Sorted by Name, I finally got the Sugart's info to stay together, but all of the others fell apart. I've attached my new db with the Family table

All good questions. This is a neighborhood database. We keep track of the kids to be listed in the newsletter for neighborhood jobs and happy birthday notices. Since we don't keep track of the adults birthdays, I will query on "widowed" to give the over 50+ club somewhere to start to invite...

I think Family will be equivalent to SpouseID. It will link both the Family and People tables.

My Family table has PKFamilyID, Family, PeopleID, and AddressID. It will join between my address and people tables in my queries. I've been working on the report using Family (long int) and it works great--however, it sorts on the Family field so really makes no sense to the user, but does keep...

If I understand correctly, your query will eliminate the wife. I need to group the wife's phone number in with the husband's without her name repeating. If you'll look at DirectoryNoPKR2.pdf (I've removed "or 2" from PKRelationship in the qryDirectory2; DirectoryInclPKR2 shows the wife) , the...

No, it was a typo. I'm not used to seeing my data like this. Here's the new file.

Database and directory exported to Word

I'm pulling from 3 different tables using 4 nested queries. What data do you want? Do you want each table? Do you want each query result?

It takes time to alter data to protect the innocent. :D I've attached two reports: DirectoryNoPKR2.pdf DirectoryInclPKR2.pdf DirectoryNoPKR2 looks like I want, however, the wife's phone number is missing. Notice the first record in both reports, Natasha has a cell phone but it doesn't show...

This is going to a long post, so I'll break it up. This is how I combine the last names: LName: [tblPeople].[LastName] & IIf([tblpeople].[PKRelationship]=1,IIf((SELECT dupe.LastName FROM tblPeople as dupe WHERE tblPeople.AddressID = dupe.AddressID and dupe.PKRelationship=2 and...

Hello All, I'm trying to create a neighborhood directory that will show both spouses' phone numbers. The report is based on nested queries. My tables have a one to many (12M) relationship: Address (pk=AddressID)-->People (pk=PeopleID)-->Phone (pk=PhoneID) In the Directory, my goal is to have...

I need to tie my DLOOKUP to my underlying record source query for the Directory report on AddressID, so I tried that as my criteria. Unsuccessful! What else can I use as a criteria?

Hello All, I am trying to "successfully" create a Directory report. I was using an underlying nested query that contained tables including tblAddress (AddressID) and tblPeople (PeopleID) to show spouses at the same address on one line of the report. There is a one to many relationship between...

Hi Steve, I appreciate your answer. I would like to build on what I currently have since I no longer have the skill set to start from scratch. My main form does show minimal info--address, whether to list in the directory, and rental. The subform has all of the data pertaining to the people...

Hello All, About 15 yrs ago I created a client db with all of the forms, queries, reports, coding, etc. Since then I've been out of the programming world and have gotten extremely rusty and lost my mad skills :) I've adapted the client db to be used for a neighborhood directory and all has...

You must have ESP! I was just working on that. The final query sorts correctly but now I'm having problems with the report. Thanks for your help! If I can't get the report sort correctly I'll post to the Report forum.

Hi All, I have 3 queries based on address that creates a neighborhood directory report sorted by address. The first query sorts fine (AddressID and Address (this is a concantenated field of StreetNo & StreetName), the sort is on Address), and then passes the results to the next query and so...