Alpha Video Training
Results 1 to 3 of 3

Thread: Altering Price Field

  1. #1
    Member
    Real Name
    John Cunradi
    Join Date
    Aug 2000
    Posts
    464

    Default Altering Price Field

    I have an import that imports a tabular/text file. This file has a price field where the price may look like this: 399
    This represents a value of $ 3.99
    When appended to a final table, it shows as $ 399.00
    I need to find a way to divide this number by 100 to create the correct value.

    I use an intermidiate table, if this helps. (import to new table then append to an existing table)

    Thanks in advance.

  2. #2
    Member
    Real Name
    Gary Smith
    Join Date
    Apr 2000
    Posts
    180

    Default RE: Altering Price Field

    One option is to create a saved operation for the intermediate table. Right click on the table, select operations, define a new operation, update records. Click the General tab and select assign a calculated value to a field. Define the expression as fieldname/100. Save the operation. You can now run the saved operation after you import to the intermediate table.

  3. #3
    Member
    Real Name
    John Cunradi
    Join Date
    Aug 2000
    Posts
    464

    Default RE: Altering Price Field

    Thanks, I'll give it a try.

Similar Threads

  1. Price changes over time...
    By Sean Olsen in forum Alpha Five Version 5
    Replies: 3
    Last Post: 04-07-2003, 08:25 AM
  2. price OK - activation PIA
    By Ford Ransone in forum Alpha Five Version 5
    Replies: 26
    Last Post: 08-16-2002, 10:45 AM
  3. Loyality vs. Price of A5
    By Fred Pfeiffer in forum Alpha Five Version 4
    Replies: 8
    Last Post: 08-03-2002, 04:18 PM
  4. what's the price?
    By Birol Gezici in forum Alpha Five Version 5
    Replies: 7
    Last Post: 07-22-2002, 08:49 AM
  5. V5 Upgrade Price
    By David Day in forum Alpha Five Version 5
    Replies: 2
    Last Post: 07-19-2002, 03:39 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •