I have two tables, some of the fields are the same in both tables. I would like to create a table that shows the common field, and which includes data from...

I am working in an education template and want to see if there is a way to create a field that can be added to periodically to show all the courses a person...

I have a form that has options to choose different reports. I want to add a comment to certain reports. What I would like to happen is when I click on a...

If I use a Dlookup Function to pull the dat from a zip code table that matches the zip code in the query used for a report. Table1 Fields Name, address,...

Two types of numbers. First type: I have a 20 digit number that will be scanned into the database and it can store with or without spaces (I am presently...

Before split my DB, I can open one of my tables. But after splitted my DB,I couldn't open that table from my BE DB. The warning message is "Property value is...

I am using Access 97 with a major query/report/macro database written by someone 5 years ago that has disappeared from the face of the earth. It...

I have read articles upon articles on relationships. Just when I think I got it I cant create more then 1 record. I know this doesn't make a lot of sence. In...

Does anyone know of a way of copying data in 1 field in a row to other multiple blank fields in a large table? I have filtered records and want to copy a...

Hello. I am creating a table that requires more than 250 fields (total of about 350 fields). All of these fields are required per record. When I couldn't...

Hello, I am trying to auto sync db schemata (in access, among other databases). Means, there is a C# application that generates SQL for generating...

I would like to set up a Database that serves as our Engineering Change log as well as lets people view information about the Engineering Changes. My Database...

i want to open my website for my organisation and my company

It is my understanding that surrogate keys are generally recommended to ensure uniqueness of records. Is it not true that using surrogate keys implies...

I need to set up a billing, payment(which also posts financial charges every 30 days after the first 30) I have the following tables: Billing Table , ,...

Looking for a reality check to see if I designed this correctly. Found a couple examples and based this off of them. A project has at least 2 sites and 2...

Hello all Windows 2K Access 2K I have designed a database which contains about six one to one relationships. My original thinking was this design would keep...

Am working in an Access tracking program at my office. I have to go through several levels to finally get to the cost information on a tabbed screen behind...

I want to modify the Northwind db example. Looking at the design, I want to include another 3 or 4 tables that follow the schema of the "Order Details". If I...

Hi, First of all I do not have much experience with split DB's. I have a DB (Access 2002) that is split. In the DB I have tables for each year eg....