Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jan 2003
    Thanked 0 Times in 0 Posts

    Multi-Field Update (Access97)

    I need to set up a form that will have a field for a "total fee", but not store it....just calculate two other fee fields based on a stored percentage and store these two. However, I can't seem to get this to work from a SQL statement in a form. Does it need to be done from VB? If so, any code examples? I would appreciate any help.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Sacramento, California, USA
    Thanked 1 Time in 1 Post

    Re: Multi-Field Update (Access97)

    You can only use SQL as the data source for the form or a rowsource for combo and listboxes. If you want a calculated control you have two choices: put the formula in the underlying query, or put a formula in its control source (i.e. "=[Value1] * .10", without the quotes and where Value1 is the name of a field in the form's recordset that you want to multiply by 10%).

    If you need more help, provide more information on the form and the fields involved. If you have a query behind the form, post the SQL for the query.

Posting Permissions

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