Search results

I have a column of alpha-numeric strings and need to find what elements are common and located in the same segment of the text string comparing all cells in the column to each other. In other words cell in row 1 = M0G001EVC07720 cell 2 = M1L001EVC14009 In this...

I deal with very large .txt files that, when imported into Excel, have to be "conditioned" via macro to "clean" the data. PROBLEM: The data (rows) is sporadic (sample following): 3/21/2008 10:26 TSC Refill E NAME 7142125 Order: 37207524 3/21/2008 12:14 AGH E NAME 7536895 Order...

I receive reports formatted as a .txt (flat) file. Problem: I have to develop a process to manage the .txt files so the data can be separated into its own fields. The layout of the output is as follows: Date Time User Status Customer Name ID# 06/04/07...

I have a table that is comprised of 2 previously seperate tables. The data sources were different for each, so the formatting of the date fields (specifically) were different. One source parsed the date fields into 3 seperate text fields for YYYY, one field for MM, and one for DD. The other...

Not sure what happened here. I now have an empty (277MB) shell in which I cannot see any tables or queries. The event occurred when the db automatically began to "Compact and Repair" in the middle of creating a new query. Any thoughts?

I have two tables: one that has (in part) call data from calls to a call center. The data includes the initiating (or calling) number/Start Date of the call/ Start Time/End Time/Duration, as well as City and State (abbreviation) of origin. I also have a table that includes time zones by state...

I have a db to count the number of times we receive calls from phone numbers recorded in MCI records. The phone number counts are "bumped" up against a customer database and those customer records [with matches on the phone number in the customer record] bring up customer information including...

I have a query used to drive a report. The report is to list each record grouped by rnCode by state (e.g. NY, NJ, CA, etc...). The report displays all records under each code for each state. I have been able to display the count (total) of the number of records for each code by creating an...

I have a Form in an A2K db related to Written Correspondence logging, tracking, and reporting. I need to activate certain fields based on the selection of the term "Complaint" or "Inquiry" from a combobox value list. "Complaint" needs to lock out "Inquiry" fields, and vice versa. Is there a...

Reportedly, IVR usage has dropped over time. I have a Date Range Query that pulls data for the range entered. I would like the user to enter time range (1) to compare to time range (2) from the same table and compare month to month, etc. Now the query shows the same time period data twice and...

Have read previous posts re: this topic but not getting results from applying them...Command Button "delete record" does not delete record. Changed code as recommended DoCmd select and DoCmd delete. Form Record Selector on left of screen highlights, but a message box pops with "delete action...

In a query I have an Expression used to capture the parameter [Enter Month as Digit]. Expr2:[Enter Month as Digit] This is taken from another expression: Month[Received Date] This is used to identify the Month the data was received. The parameter [Enter Month as Digit] is to be...

I have built a database over time, but failed to establish referential integrity at the outset. Is there a method by which to do this after the fact? What should I be looking for in fields, etc that will create problems? Anything that you can provide will be appreciated. Thanks.

Access '97 - Database is used to accumulate performance data on Employees. Some are Contract (temporary) and others Permanent. If a Contract employee is hired, they receive a different and permanent EmpID. There is a form that allows a supervisor to change the ID number and update the...

I have a db with scores (various performance characteristics of job functions)that are collected several times per month and then summed or averaged based on our needs. I would like to compare the data side-by-side and month-to-month to measure changes over time. I have queries that pull the...

I have Excel Spreadsheets loaded into 2 Access '97 db's. The Spreadsheets contain a field marked "Customer Name". One SS has the Customer Name loaded as FName MI LName. The other has the Customer Name loaded as LName, FName MI. Both SS's have the Name in one cell regardless of the...

I am having difficulty with a form that is capturing info on correspondence received from customers. I want to have a seperate form pop-up when the "Correspondence Type" field is populated with the term "Complaint" from a drop-down list in a combo box. The form "pops" but it pops regardless of...

I have read through many of the questions related to this, but am not clear on how to achieve a "Comment" of "Exceptional (98-100)", "Satisfactory (95-98)", and "Needs Improvement" based on the value of a field "Total Score" which adds the various points in categories on a form. The "Total" box...

I am confused by the apparent limitations on search criteria for multiple fields using "between_and_". I have a table with 10 fields. Standard fields with customer information, DATE, Amount, Carrier, Zip Code,etc. I am able to query successfully when I use DATE criteria Month[Enter Month as...

I am unable to locate information on converting time for display in forms or reporting that converts gross numbers of seconds into Hrs:Mins:Secs. I receive raw data for phone activity that only reports in seconds. I have to convert into decimals of averages of minutes, hours, etc in the query...