Results 1 to 2 of 2

Thread: Math functions

  1. #1
    Join Date
    Jun 2003

    Question Unanswered: Math functions

    Good Afternoon LAdies & Gents

    I was hoping you could assist me with this problem (more of a how-to)
    I have a Database with 4 Tables and I need to incert some mathamatical functions to get totals, averages, percentages etc.

    here is my problem

    I have the following Tables

    tblPrice, field(s) mfg_price, discount_price, ltc_price
    tblCustomer, field(s) cpny_name, contact, address, phone, date
    tblProduct, field(s) crt, server, notebook,
    tblInventory, field(s) StockID, cust_num

    I need to be able to combine the contact name from tblCustomer, with the product purshased from tblProduct, in addition with calculations

  2. #2
    Join Date
    Jan 2003
    Nottinghamshire, UK
    C my Post 2 u'r other Query n start looking @ Grouping SUM() etc,

    "Everything should be made as simple as possible, but not simpler." - Albert Einstein
    "Everything should be made as complex as possible, so I look Cleverer." - Application Developer

Posting Permissions

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