Search results

  1. B

    relationships?

    Hello all, I am using Access to build a database to track cell phone minutes, charges, etc. for a business of about 250 numbers. I have a back end master employee database which I intend to use to keep integrity. After that I am running into trouble setting it up. I need to be able to track...
  2. B

    Table Relationships and design

    Hi all, Here is what I would like to do, and I hope someone can help me: I want to build an Access database that tracks ticket sales. Here are the tables I have so far: Customer: customerID, companyname, address, email, phone, etc. Orders: orderID, customerID (to link to which customer...
  3. B

    Make a form run off of a query?

    Hi all, I am trying to make a form with fields that will run off of a query, rather than a table. Here is the problem. The field that dictates the query is set to "is not null" so I want only entries that have something in that field (it is a cell phone number field). When I go to add this...
  4. B

    Update Query HELP

    Hi everyone, here is my dilemma. I am making a "paid time off" from work database. There are three tables I am working with: vacation_days, sick_days, and personal_days. In the vacation_days table, I have three fields: earned_vacation (days earned for the specific month, by accrual rate)...
  5. B

    Calculating Time

    Hi Everyone, I am making a database that tracks Employee's vacation/personal/sick days. I want to be able to automatically calculate accrual rates based on the time a specific employee has been working here. For example, our organization accrues 0.84 vacation days per month if you have...
  6. B

    User Friendly Query

    Hi all, I have a simple question. I have made a database that tracks deposits and also has several fields pertaining to these deposits (company, date, etc.) I need all of these fields to be searchable, sometimes even searching on a combination of fields. Obviously this is easily done in...
  7. B

    Database Design

    Hi everyone, I need to design a database to hold all deposits made to our company. These deposits come in "batches" ranging from batch 001-999. So for instance, batch 001 may have 10 deposits, then it will be closed. Batch 002 may have 7 deposits, then it will be closed. The batches may...
Back
Top Bottom