Hi i have 3 tables with relations... SELECT dbo_v_Configuration.SEARCH_CODE, dbo_V_SERVICE.NAME FROM (dbo_V_CONFIGURATION_ITEM_ON_SERVIC INNER JOIN...

database needs to record up to 10 rooms, bookers, dates and times.

I have 4 types of users: 1) administrator - full control 2) president - allowed to READ anything 3) sales director - allowed to READ/WRITE/DELETE any record...

I have a table that holds numbers (access codes) for members of a gated community. The numbers are limited to 4 digits and I've selected some of them for...

Hi All! I want to create a ("status") field in my contracts tracking table to tell me the status of the contract based on whether or not some other fields in...

Hi all, In table design view for a text field I am aware that by using the '' or '' I can make the text appear either in Upper case or Lower case. However...

Hello everyone, I need to design a database that I can keep the stats for my son and daughters basketball games. I was wondering if anyone already has...

I have 2 tables. Peoplesoft_data which contains employee info and GC which contains course info. The primary key in both of these tables is the employeeID. I...

I would like a field in a table to be recorded as a julian date for the date entered. So whether I enter a date from 2003 or 2007, the field would record the...

I'm in trouble with three of my tables. 1) tblCommunities (CommunityID is the PK) 2) tblModels (ModelID is the PK and CommunityID is the FK) 3) tblSalesLeads...

I am designing a database that tracks usage of corporate jets for personal use. This is considered income to the employees that use the company planes for...

Hi All, I have the following 3 tables: Unit Table ------------ Unit Number (Primary key) Unit Name Unit Maintenance Index (UMI)

Is there a way to specify a "From" email in Access? I want to send this from a specific mailbox. I am using Outlook that does not support seperate...

I have a table with too many fields and im wondering what some of your ideas are. I am tracking employee training and there is a field for enrollment date,...

I am setting up a database that will track the awards that personnel are awarded. The relationships will be many to many I think? I want to see how many...

The value you entered isn't valid for this field. You may have entered text in a numeric field... The table I am drawing the list from is a single list of...

I am new to Access and working to create an automated way for our service reps to track their calls. Can someone take a look and provide some...

Can anybody help? I have been upgrading an old payroll system in Access now that we have Office 2007. The original system that I inherited calculated the...

I "inherited" a database, and the person who created it turned a feature off that I need to turn back on. When you click on a combo box, a message appears...

I am designing a database for a client to track budget data. The labor data is entered by FTEs (Full Time Equivalent Employees) and the dollars are...