Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. brialex

    Rounding currency

    ...else replace(sug_retail,right(sug_retail,2),50) end as NewPrice or for the full version: case when right(cast(round(((itw.lst_cost) +3) * 1.43,2) as decimal(8,2)),2)> 50 and right(cast(round(((itw.lst_cost) +3) * 1.43,2) as decimal(8,2)),2)< 95 then...
  2. brialex

    Rounding currency

    Does anyone know of a way to round currency to the nearest .50 or .95? I need to calculate the retail cost of an item by taking the price + $3.00 * 1.43 and round it to the nearest .50 or .95. We always want to round up for example 47.44 would be $7.50 and $7.51 would be $7.95.
  3. brialex

    Increment a field by 10

    Thanks Denis!
  4. brialex

    Increment a field by 10

    How would apply that is this scenario: I want to insert approx. 3900 records into table A but I have to look at table B in order to make sure I am pulling the correct records. For example: insert into cpnpmi_t (pmo_cde,itm_num,bil_cur,pmo_chc,pmo_cde1,seq_nbr8,itm_num1, sub_chc) SELECT...
  5. brialex

    Increment a field by 10

    I am trying to find a way to increment a field by 10 for each new record that is inserted into my table. The current value of the field is 00000000. I would like each record after the original to increment by 10 when added such as 00000010,00000020,00000030.... Can anyone show me how to do...
  6. brialex

    Sharp Develop not recognizing XML closing tags

    Thanks Steve.
  7. brialex

    Sharp Develop not recognizing XML closing tags

    This will be a bit lengthy but here is some of the source BuildFileForm.cs using System; using System.Drawing; using System.Windows.Forms; using System.IO; using System.ComponentModel; namespace FFB { /// <summary> /// Description of BuildFileForm. /// </summary> public class...
  8. brialex

    Sharp Develop not recognizing XML closing tags

    All of the fields that have <tag/>, meaning the field is empty, pop up with an error that say field name can't be found. If I change the XML to <tag></tag> the file runs through just fine.
  9. brialex

    Sharp Develop not recognizing XML closing tags

    I am using a SharpDevelop program that takes an XML file and converts it to the format I need for data upload. The client is send the XML file with <test/> as the closing tag when a data field is empty instead of <test></test>. Does anyone know of a way I can change those tags to a well fromed...
  10. brialex

    SharpDevelop program coverting an XML file to desired layout

    I am using a SharpDevelop program that takes an XML file and converts it to the format I need for data upload. The client is send the XML file with <test/> as the closing tag when a data field is empty instead of <test></test>. Does anyone know of a way I can change those tags to a well fromed...
  11. brialex

    set item count to 0001 when only one donor/ increment by one when more

    Here's some sample data. The first column is order number and last column is donor number. For the first record I would like the itm_nbr to be 0001. The itm_nbr for the second record should be 0001 and 0002 for the third record since record 2 and 3 have the same donor number and order number...
  12. brialex

    set item count to 0001 when only one donor/ increment by one when more

    The donors each have a unique id assigned to them, such as 010000068070. If the same donor number appears twice you know that the donor has multiple gifts(donee's). The layout of my table is as follows: I need to populate the itm_nbr field with the record count as descibed. select ord_nbr...
  13. brialex

    set item count to 0001 when only one donor/ increment by one when more

    this is what I have so far DECLARE @count int DECLARE @pos int DECLARE @total_subs int DECLARE @N INT SET @pos = 1 SET @total_subs = 228 SET @n = 1 SET @count = 0 -- Declare temp variables to store row data DECLARE @v1 char(12) -- Declare cursor selecting correspoding data with temp...
  14. brialex

    set item count to 0001 when only one donor/ increment by one when more

    I need to update a table with item numbers for each record. For example if the donor only exists on the file one time, his item number would be 0001. however if the donor exists on file multiple times I need to set the first item number to 0001, the second to 0002, and so on. Any help would be...
  15. brialex

    Microsoft Query - datasources - SQL Server error.

    Thanks!
  16. brialex

    Microsoft Query - datasources - SQL Server error.

    Yes the should have access to the table. The table has permissions set to all users. I have other reports that are pointing to the same server just a different table and they are working fine. Trisha
  17. brialex

    Microsoft Query - datasources - SQL Server error.

    I created a query within SQL that I am trying to use as an external datasource within excel. I made my connection to the SQL server and told it which table I wanted to use. Everything seems to work just fine under my login but when someone else tries to open the file that is not a domain...
  18. brialex

    My computer won't load properly

    I did not add anything new or change anything in the operating system or BIOS settings. Yes it was shudown properly and I did not notice it being overly hot before this problem occured.
  19. brialex

    My computer won't load properly

    I do not receive any error messages but when I turn the computer on it loads all of the system information and then just goes to a black screen with a cursor flashing in the upper left corner before it even gets to the Windows splash screen. I just had the computer on a couple of days ago and...
  20. brialex

    Adding and substracting numbers in a Microsoft Access Table

    I am trying to find a way to create a general ledger within an Access table so that I can report off of it. For example, I have withdrawals, deposits, and balance forward. I can't seem to find a way for the balance forward to automatically update instead of figuring the amount manually and...

Part and Inventory Search

Back
Top