Greets, I have the following problem: 1 Table holds information (StreetID, StreetName, PostalCode, Area) StreetID=PK Unique values only in StreetID 2...

Hi, I have 2 tables that are linked together by a field called MemberID. Table1 has MemberID as the primary field. When I originally designed the database,...

I am trying to normalize a db that I have imported from an ODBC source. I have 2 sets of 6 different fields that I want to combine into 2 fields. Example of...

I have many records that have a field in common (SBL) but different owners names. I would like to have one record with SBL and all the owners names listed.

I have the employee name separated by LastName & FirstName (2 separate columns) in my TblEmployee. In my report, would like to combine the last and first...

Okay I have made my database with the fields of: Monitor_Well, Date, Specific_Conductance, pH, Antimony, Arsenic, Barium, etc. There are several Monitor Well...

I built a table use several fields with similar date; ex name 1, name 2; I have lots of records in each field; how do I move the data from field Name 2 to Name...

I have several of the same fields in two seperate tables: Shipping and Receiving. When a shipment goes out it has a RMA, PO# and a Serial# etc. These fields...

I have found two Access templates that have tables I need to incorporate into one database. How do I combine the Events Management and Membership templates so...

Folks, Please excuse me if this is an obvious question, but I haven't been able to find any information on this. I have two tables, as follows: Table one...

I am working on an Access Database in Access 2003. There are two main tables that hold the most important information. There is some information that is in...

Hi, I have 2 tables that are being updated by 2 seperate users at different sites Table 1 ID Site Product Date Weight

I want to setup a P.O. # field that takes the date the order was placed and combines it with an incrementing number. I would like it to look like 120507-001,...

Hello, I am interested in building an Access application as a gift for my employer. Essentially I am looking at Order Processing, Service Calls, & Product...

I have a table where I need to combine a auto-number field and a text field to creat a new field which can be either a number or text. Any suggestions on how...

I have a existing database with a table in it called parts, and in this table there is a column called word one and one called word two, i need the...

Hello: I have not used access in ages and I have 2007 installed in my computer. I have checked in the microsoft templetes and there are 4 different...

We have a tracking system setup on the network and one of the users performed a local save to their computer and have been working off of the same database as...

I'm trying to group a number of fields from one table into one separate field. Basically, the table lists address information: state, zip, city, street. I...

I have a shipping table in which the user enters/selects a "Ship To". The user first selects an option button for whether a "Customer" or "Other" will be...