Results 1 to 2 of 2

Thread: generate list

  1. #1
    Join Date
    May 2009
    Posts
    72

    Unanswered: generate list

    Hi

    I have a form called WAGE CALC...derived from a table
    on this form I have a unbound calculated field called BASICPAY

    I have a table called DEARNESSALLOWANCE
    in this table I have the following fields
    slno---primary key
    damonth---- list of months
    dapercent---neumerical value

    what iam trying to do is..
    I need to generate a report where the basicpay is multiplied with dapercent for every month listed in the damonth

    any help will be great
    thanks
    hemanth

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You could use (provided that the form is open):
    Code:
    SELECT [dapercent] * Forms![WAGE CALC]![BASICPAY]
    FROM [DEARNESSALLOWANCE];
    Have a nice day!

Posting Permissions

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