Search results

  1. B

    Group By with distinct values across records in one field

    I have an Access table, named Events (see attached screen shot) where I want to group 4 fields: EVENT_MONTH, EVENT_TYPE, LOCATION, and SOURCES. Summarizing just the first 3 fields is simple. But what I want to do with the SOURCES field is select distinct values across records (don’t know if I...
  2. B

    Update values in one table from another

    In MS Access I have a table named Master that periodically needs to gets updated with ‘updated’ data from a table named NewData. Each table has the same fields, except Master has one additional field named OTHER_SOURCES (explained further down). They each have an indexed unique id field named...
  3. B

    Self Joins and Many-to-Many Relationships

    Relatively new Access user and first-time poster. My question pertains to self-joins and many-to-many relationships. The ‘rough’ database I created thus far involves relationships among individuals, sort of a genealogy concept. I will eventually grow this to try and show many-to-many...
  4. B

    Hello from Florida, USA

    Hi, I have been using Access for 1 1/2 years. I am comfortable creating tables, forms, and queries through design view (still figuring out the SQL thing). I have 'borrowed' vba code from others and tweaked it to suit my needs, but I am still a novice. Thank you, Jim
Top Bottom