Search results

Sorry for cross-posting. I posted this in the Tables forum, but have had no replies in over 12 hours. I searched on IMPORT (72 threads), but didn't see anything like the problem I have. I have a large Excel file formatted thus; COLUMN A 1 Full Name 2 Full address 3 City State Zip Columns B...

Greetings, I searched on IMPORT, but didn't see anything like the problem I have. I have a large Excel file formatted thus; COLUMN A COLUMN B COLUMN C 1 Full Name 2 Full address 3 City State Zip 4 Phone SSN Sex Alas, as you can see, the first...

Greetings, I am using Access 97 at work, Access 2000 at home. This is a work project. I have a database that tracks employee awards. One type of award is the Peer Award. An employee can receive more than one award during the reporting period (01 May 05 through 30 April 06), but an employee...

Greetings, Have an address list with over 600 names, and I need to create mailing labels. Have First Name, Last Name fields, with city, state zip. BUT... There is also a field called SPOUSE. This field is NOT always populated. I need a query that I'll use to create the mailing labels that...

Greetings, I have a friend who is using Excel to track a Greyhound Protective Association roster. These are folks that foster and adopt Greyhounds -- thus a worthy cause. It has over 600 rows of data. I've attached 50 rows of sample data in Excel format. Along with contact information...

I have a report that I have printing 5 line per page. Now, I have a requirement to have the report not only print 5 lines per page, but when a contract number has more then 5 lines, then I need to have THAT contract number print all of its lines. Example: Many of the lines contain one or two...

Table Design Access 97 Greetings. Apologizing in advance for the lengthy post. Looking for clues on the best method to capture data for a management report. I have to capture and report on several categories pertaining to Performance, Leave and Discipline. I'm currently using Excel, but...

Greetings, Searched the forum for a method to convert a Positive Number to a Negative Number based on the data in another field. Could not find anything. I get data in Excel 97 which contains a field called DetailAmount. All of the numbers are positive. Another field called TransactionType...

Work-Access 97 SR1 Home-Access 2000 Greetings, Analyzing Time and Billing. I receive a flat file in Excel every two weeks, which I append to an Access file. A large portion of the analysis is capturing errors between the HourTypeCode and WC5. As of now, I have over 12K records to process...

Greetings, (Access 97 SR1) I have a finance & acctg database that has three tables in it (Army, DoD, Other). Using macro to; 1. Link to external info. 2. Delete the records in the permanent tables above. 3. Append new records from linked info into the appropriate table above. PROBLEM The...

Good Morning, Using Access 97 SR2 I've been tasked to determine user errors on a new timekeeping system (eBiz) that we are using. In one payperiod there are over 1600 records. I've searched the REPORT threads for using multiple criteria in Conditional Formatting, but have not seen anything...

Greetings, I have a Main Form with a Tabbed SubForm. The Tabbed Subform has two tabs, which are two subforms that I dragged and dropped into the applicable tab. My first tabbed subform is synced to the main form, and works properly. However, the second tabbed subform isn't synced. I've...

Hello all, I'm using Access 97. I have 2 tables in a One-to-Many relationship, 1. t_PO_Contract - PK = Num_PO_Con / One 2. t_CLIN_and_FSN - Key = Num_PO_Con2 / Many These contracts can be processed by more than one activity (DFAS or DAFS). Example: Num_PO_Con = 523204 This particular...

Using MS Access 97 SR2 Greetings, I have been tasked to devise a method of determining which activity has made the most payments against a contract. Most contracts are paid by one activity against one or several line items on the contract. However, sometimes there may be two or more...

Greetings, I am using Access 97 SR2. I want to take an unbound form and create summary information using unbound text boxes for calculations. I'm thinking I need to use DSum and DCount. I have 24 work organizations that I'm required to track their total work hours and total overtime hours by...

Greetings, I am using Access 97 SR2 I have a similar problem I'm trying to address. I'm trying to count the number of employees who have arrived and departed within the past month. I'm using an unbound form, which is heavily populated with other DCOUNT textboxes. I need something like...

Greetings, Up front, I am posting this question in both Access-Queries and Excel forums. I am using Access-Excel 97 SR2 at work, and Access-Excel 2000 at home. I have a large Excel file where the addresses are all in one field (Address). Here are some examples: 807 E.South St. Apt.33 Crown...

Greetings, Using Access 97, SR2. I have a query and a report that lists employees with college degrees. The criteria is that the degree was completed sometime during: A. The current fiscal year (10/01/2001 - 09/30/2002) B. The previous fiscal year (10/01/2000 - 09/30/2001) C. Show all for...

Greetings, I am using Access 97, SR2. I have a form that tracks developmental assignments of employees (frm_DNO_Developmental Assignments) . On this form I have a subform (sbfrmDevelopmentalAssignments). The subform is set to display continuous forms. An employee can have more than one...

Greetings, I've searched on Update Queries, but didn't find anything to do this. I am using Access 97, SR2 I have a text field called BLK, length is 3. I need to replace the first character with the number 9, regardless of what the other two characters are. Example: Current data: 0L3...