Results 1 to 2 of 2
  1. #1
    shanky365 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2011
    Posts
    13

    formula with two tables

    i have defined "Quantity" and "toatl cost" in one table and "issued qty" in other table... nw i wanna find the rate of item... whih will be cost/qty wich is in 2 diff tables? how to do this?

  2. #2
    GinaWhipp's Avatar
    GinaWhipp is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jul 2011
    Location
    Ohio, USA
    Posts
    377
    I want to say a query but without knowing how these tables relate to each other not sure it can be done that way. It would help if you post the table details and how they relate to each other...

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Formula mod help
    By jcaptchaos2 in forum Access
    Replies: 2
    Last Post: 04-25-2011, 02:55 PM
  2. Default Value by formula
    By sparlaman in forum Forms
    Replies: 15
    Last Post: 04-04-2011, 12:32 PM
  3. SQL Formula to Sum Itself
    By Scorpio11 in forum Access
    Replies: 1
    Last Post: 02-19-2011, 11:22 AM
  4. Formula
    By hschrunk in forum Access
    Replies: 3
    Last Post: 05-18-2010, 01:40 PM
  5. Max formula in Access
    By mohsin74 in forum Programming
    Replies: 2
    Last Post: 12-26-2006, 07:21 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums