Search results for query: *

I have some small tables (ie Jan, Feb, March etc.) I want to append all of them into one big table. From the table tab I do a copy of Jan and try to append Feb. or I do a copy of Jan and using Query tab I do an append query. Either way I am getting an error and cannot get these into one table...

I have a file I receive from an outside vendor monthly. The problem is the address is ADR1, ADR2, ADR3, ADR4 and ADR5. But, depending on the Address you never know what Address field the State and Zip code will be in. Therefore, I have concatenated Adr1-5 into another field. Now I need to...

I need to take yesterdays pending balance and add it to todays avail to process-todays processed. For example: Date: 11/19 Pending= 563 Date: 11/20 Aval to Process= 78; Processed=235 Add: 563 (from yesterday) +78=641- 235 (processed 11/20)= 406 Pending. I have two linked queries that...

I have a couple of questions about using MSGraph. 1. I developed my chart through the wizard. When I am editing my line graph how do I edit MY data rather then the MSGraph "SAMPLE" data? My data includes more lines than the sample data and I can'f figure out how to manipulate the...

I created a table in MSWord that expands over about 6 pages. Somehow I got myself in an Outline format and cannot get out. I can display the master document, but I just want a regular normal document and not an outline format at all. At this point I am trying to split the table and insert...

I am exporting data from a Call Center appl. (CentreVu by Avaya communication. The report I export has time in hours:minutes. I import the data into a number field. However, I cannot convert the number value to hours:minutes and have the hours:minutes MATCH. Any ideas? I have even tried...

I have two separate databases. From one database I am linking to a table (personnel) in another (employee) database. Our server is local here on the west coast. However, the application is being used on the east coast, as well. The problem is the server here (west) is identified as V:\ but...

I am looking for a simple solution for some un-sophisticated security. I have tried the MSAccess security without success. Therefore, I am looking for something else. My application is individual's job objectives. Each of 7 people will either update their Excel spreadsheet (which is the...

I have an Employee and Geography tbl. I want to report on information from both tables. Terr Emp Name Ext States covered 123 Karen 999 AZ CA NM 234 John 777 VT WV PA CAN I DO...

I am using two different ASCII text files. My customer's file and a download of my data (from Siebel). Based on a common identifier in each file, I link the files together. In my report if the record in my file matches the record in their file, I want to use my files name, adr, telephone...

On a telephone (text) field. Is there an easier way to remove the formating. I currently use a series of update queries using left(telephone)13, left(phone,3) left (6)right (4) ext. It takes about 5 queries to get rid of the (brackets) and xxx-hyphen. I am sure there must be a function which...

I have created a form where I would like to count records from a table based on a criteria. I want to do a headcount from a personnel table. ie. FORM: field=Customer Support Rep. Unbound field=Count(Title)="CSSR" field=OrderProcessing Unbound field=Count(Title)="OP" etc...

I am downloading data from Siebel and importing it into MSaccess to generate reports. I import the date fields as text because I am receiving errors when I try to import them as date fields. Once the date has been imported, I change the text field to a date field. The problem is that the...

I want to use a macro which will take data in the table (or from the result of a query) and download to ASCII tab delimited. I designed a macro using the transfer text action and specified a path. But, when I run the macro NOTHING HAPPENS... can you help? Karen

I am trying to clean up an address field where the address includes PO Box.  I narrow down my update by setting criteria, but then how do I update PO box without touching the various numbers.  I added a new field called revised address 2 and tried using an update query...

I have a spreadsheet linked into my MSAccess database.  However, when I try to run my macro which appends the data I notice not all records are being added.  For example there are 401 total records in Excel.  However, only 387 records are imported.  Have...

I have set up an application for ordering literature.  The ordering is automated in the field via telephone.  The orders are downloaded from PROCOM into a *.txt file or *.xls format.  The user runs queries to delete old data and then imports new data.  The...

Using downloaded data from another application (ASCII .csv formatted file).  The .csv file is linked into MSAccess using macro's I get the data from .csv file into a table called ANALYSIS TABLE.  The problem is ORDERED date field (ie. 1/6/00 instead of 01/06/00)  I...