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...

I am using the send mail task.

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...

Sorry, here are the formulas @PrintRunningTotal = IF {@Grouping}>=1 AND {@Grouping}<=5 THEN 1 ELSE IF {@Grouping}=6 THEN 2 ELSE IF {@Grouping}>=7 AND {@Grouping}<=9 THEN 3 ELSE IF {@Grouping}>=10 AND {@Grouping}<=13 THEN 4 ELSE IF {@Grouping}>=14 AND {@Grouping}<=19 THEN 5 ELSE 6 I am trying...

Thanks for the suggestion. I deleted the CDX files for ICILOC, ICIQTY, and ICITEM and then reindexed the system. The error is still there. It started with one item. 3 items are now affected. We have over 3,000 items so I find it strange that only a few are impacted.

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...

It is actually an "internal consistency error" message that we receive.

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...

None of the above has helped. I cannot ping the IP address that is displayed as the destination in the audio monitor. Would that be the problem? If yes, does that require a reboot of the Definity System to fix?

I do not see anything on the login screen that specifies the connection speed. I connect to the lan at 1.0/Gig.

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...

I have my test environment setup on another computer with a shared hard drive. I just change the drive mapping when I want to work with the test environment. Just remember to map it back to live data when you are done.

I did locate a relatively inexpensive Outlook add-on product to handle this situation that I am currently testing. The product is less than <$1,000 for an unlimited license. I cannot give you the product name or website due to tek-tips rules about promoting products. You should be able to find...

It sounds like your client posts in summary from the various modules (AR, IC, PR) - so the answer is no. By doing a release to GL in summary, only the total amount for each account is posted. The detail stays in the module which generated the GL batch - as long as he is not deleting history...

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...