Search results for query: *

Hello, I am trying to create a pivot table in Excel from an Access Database table. I am getting duplicate and triplicate column headings in the Pivot Table. The grand totals in the Pivot Table are correct, so it is not reporting the same data twice. I first thought there might be a formatting...

New to SQL and I am really struggling with some of the concepts. I am trying to calculate how many orders have inventory available. I have 2 temp tables; table 1 has columns - order#, SKU, qty ordered, qty available. table 2 has columns - SKU, qty on hand I am trying to write a loop that will...

We have a DTS package in SQL 2005 that e-mails a file to a group at the end of processing. The package runs fine and everyone receives the e-mail with the attachment. The problem is that the attached file has the full file path as its name when it goes to recipients outside our network...

We have a DTS package in SQL 2005 that e-mails a file to a group at the end of processing. The package runs fine and everyone receives the e-mail with the attachment. The problem is that the attached file has the full file path as its name when it goes to recipients outside our network...

I am not familiar with the SQL program language. I am just trying to make a quick modification to a program. The program is suppose to pull records from 01/01/lastyear to today/lastyear (01/01/2006-05/17/2006). I can tell that the code is not correct based on the data retrieved. Can anyone...

New at working with Crystal, so you will need to be patient. I have a report with a running total named "Daily Total". I also have a variable "print running total" which will equal 1 to 6. I am trying to reset "Daily Total" back to zero after "print running total" = 3. In "daily total" I have...

We are running SBT 6.5. For the last week we have been receiving an "internal inconsistency error" during shipment processing. No error is received when entering shipments. It only appears when you process the shipments (create the invoices). At first it was happening on only one item. Now...

I am new to access and struggling with a query. I am pulling data from an odbc table which stores the information in rows. I need to move the data to columns in a query. The data exists as emp1 ded1 amount emp1 ded2 amount emp1 ded3 amount emp2 ded1 amount emp2 ded2 amount I...

We are using a Definity S8500 system. I recently had to replace my PC requiring re-installation of the IP Softphone on my PC. I can no longer hear callers when using the IP Softphone. The caller can hear me when I speak. This was working on my old PC. My speakers appear to be working fine. I can...

I have an excel template setup with all my preferences that I use whenever I start a new spreadsheet. I am using the &[file] command in the print footer to display the file name. I would like to print the file path & name in every footer. Is there a way to add a command to the template that...

We use ProSeries 6.0. Since closing my last period, users get the error message "Header Record not Found" when clicking on the 36-month history on the item inquiry screen. My ichist.dbf seems fine. I am guessing that the problem is with the table that displays the dates on the inquiry screen...

One of my users is having a problem replying to certain messages in Outlook 2000. He will only get a single tilde(~)sign when he types. This is not happening on all messages, only certain messages. I cannot see any similarity in the messages that he cannot reply to. He can also have several...

Can someone help me with the best practice in locking a record while updating? I am trying to update an existing program that occasionally does not update the record. I have looked at other existing programs and the Microsoft knowledge base. There are several options. I am trying to determine...

I use Microsoft Query to import data from various databases to Excel. I would like to join two tables in Query that reside on two different computers. Is there a way to join two tables that reside on different servers in Query? Until now I have always copied one table to the other server and...

I purchased a mailing list from a marketing company. I need to append the data to an existing mailing list. The database that I received from the marketing company contains 5 character string fields - addr1, addr2, addr3, addr4, addr5. Browsing the data, the name is in addr1 and the first line...

I am using Pro Series 6.0 payroll module to pay employees in several different states. Some states allow any 401K contributions to be deducted from gross pay before calculating the state withholding tax while others do not allow the deduction. One of the states has just changed from not...

Really dumb question, but I am stuck and the staff at my local computer store cannot help. I am trying to transfer files from my old PC to my new PC using the File Transfer Wizard in Windows XP. Both are stand alone PCs - not on a network. I cannot get the 2-PCs to link. Here is my question...

I have been asked to create a grid report which would list the SKUs in production across the top (columns) and the raw material items listed down the side (rows). The grid would contain the quantity needed of each raw material to manufacture the SKU. My problem is that the column count will be...

We are discuss upgrading to ACCPAC ProSeries Version 7.3 and at the same time moving to the SQL platform. Has ACCPAC consolidated all the current and history files (i.e. sotran and soytrn) into one database on the SQL platform, or are they still separate?

Hello, I need to create a comma delimited file from a FoxPro table to send to a customer for import into their system. I cannot use the COPY TO command because the records are of various lengths and the customer does not want blank fields - example HEADER1 FIELD1 FIELD2 FIELD3 ...