Search results

  1. P

    Masking Query Results based on Criteria? Access 2010

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

    Masking Query Results based on Criteria? Access 2010

    This is the latest db with the Family table.
  3. P

    Masking Query Results based on Criteria? Access 2010

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

    Masking Query Results based on Criteria? Access 2010

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

    Masking Query Results based on Criteria? Access 2010

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

    Masking Query Results based on Criteria? Access 2010

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

    Masking Query Results based on Criteria? Access 2010

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

    Masking Query Results based on Criteria? Access 2010

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

    Masking Query Results based on Criteria? Access 2010

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

    Masking Query Results based on Criteria? Access 2010

    Database and directory exported to Word
  11. P

    Masking Query Results based on Criteria? Access 2010

    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?
  12. P

    Masking Query Results based on Criteria? Access 2010

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

    Masking Query Results based on Criteria? Access 2010

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

    Masking Query Results based on Criteria? Access 2010

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

    DLOOKUP underlying Control Source in Textbox

    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?
  16. P

    DLOOKUP underlying Control Source in Textbox

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

    Is a tabbed subform my best solution???

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

    Is a tabbed subform my best solution???

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

    Passing a sort thru nested queries???

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

    Passing a sort thru nested queries???

    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...
Back
Top Bottom