Search results

  1. D

    Repeated Values in One-to-Many Query

    Good Morning, I'm in the process of reformatting a database at work, which contains drug-related incidents. There are two tables; incident/victim information and packaging color. The goal of my query is to be able to specify a date range and return all incidents for that time period...
  2. D

    Importing Old DB into New

    Greetings, At work I have inherited a database from a predecessor that is incredibly inefficient. In essence, it contains case information and subject information where there can be multiple subjects to one case. For example this is how it is entered: Date Location Subject Name...
  3. D

    Multi-Table Query Question

    I am in the process of building a database that contains tables for Personal Info (Name, DOB, License #), Addresses (Street, City, County, State), and Phone Numbers. I have done this because one person often has multiple addresses and/or phone numbers I have successfully linked the tables with...
  4. D

    Question Option for Multiple Entries in One Row?

    Hi there, I am pretty new to Access. I was wondering if there is a way to allow for multiple entries into a single row/column. For example, Some entries (people) in my database will have multiple addresses and /or phone numbers. Rather than having to have columns with "Address 1", "Address...
Top Bottom