I am building an employee production db at work. The problem I am having is with the relationships and maybe my table design. I have one table for employee,...

I am comparing data from two tables and wanted to create a field in one table that will only search by the first 6 or 8 characters, because we have some...

Hello, I was builiding a database for co-worker of mine. I have a form with drop down box with usernames, Status and when status changes to "Complete" it...

Here is my challenge. My work has a wretched almost unsearchable "database". I am trying to cobble together my own relational database from that...

I want to add a child table to my table and using one of the primary key of the table. For example: MyTable is PKey1 PKey2 PKey3

I am a self-taught novice (the worst kind!) so am hoping I can get a nice simple answer to my question. First the history: I want to re-build a database...

How do I make a field on the profile page in an Education template that is a link that would bring you to a detail page where lists of courses a student...

I have posted a query on the subject but i don't remember the exact date. How to find our my query and know whether it is answered or not.

I have a design problem that has me stuck. I'm modifying a system. It currently supports internal clients who are retrieved from a userdirectory table. This...

My last two poses on the "Microsoft responds....." thread never showed up/

Access 2003: I have a database containing contact information and other attributes for members of an organization. Some of those members work for...

I have a table that I delete all records from/then append records to on a daily basis. I modified the table by adding another field. My Append query now...

Hello, Not sure how to approach this: We have an inventory database that has a variety of item types. Workstations and printers have quite a difference...

This is more of a design question about how data should be stored in a table. While importing information from Excel, some records in the same field have...

Hey Group, I have a table with the following Feilds: MobilePhoneID, PrimaryUser, DepartmentID, CallOptions, MobileNumber, SDC, GPRSTarrif (Lookup to Another...

I have PMs that are due - sometimes within 1 day and sometimes within 3 days. I record the date done and have a query extract the next due date. When that...

(Access 2000) i want to create a database to manage clients where i can create exercise workouts, manage body measurements and create reports even possible...

on just a PART of a field? Here's the structure so far: Access 2000, 3 tables (Furniture, Titles, Descriptions), no joins. Here's the design & some sample...