Search results

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

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

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

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)...

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

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

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