Search Result

Collapse
8 results in 0.0039 seconds.
Keywords
Members
Tags
calculation
  •  

  • Karl Raams
    started a topic Possibility List Calculation

    Possibility List Calculation

    Hi Guys,

    I've got this unique situation that I've never come across before. What I want to do is create a piece of code that will add to a list all the possibilities based off of settings that have been set.

    What I currently have is a list of possible entries that looks somthing like this:
    1. S
    2. M
    3. T


    I also have an entry in the program where the user defines how many spaces there can be. For this...
    See more | Go to post

  • asmodea
    started a topic DSUM with fields from different tables?

    DSUM with fields from different tables?

    I am trying to add a calculated field in my query to sum the payments up until the date of the entry. There are two tables involved. I have a table for the dates and amounts of wired payments ("KYOWAPayments ") as well as a table of invoice# and shipping information ("AP statement log"). The two tables have no relationship.

    I wanted to make a field that will automatically calculate the sum of all wired payments up...
    See more | Go to post
    Last edited by asmodea; Apr 13 '12, 06:27 PM. Reason: Saw a potential cause of confusion in question.

  • Form with some calculation but input fields are resulting to NaN.

    I am trying to do some calculation with this form but some input fields are resulting NaN. Can anyone explain the error and a fix? Thanks


    Code:
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html;
    ...
    See more | Go to post
    Last edited by Dormilich; Apr 27 '11, 07:55 AM. Reason: please use [CODE] [/CODE] tags when posting code

  • Why does form calculation work with text but not with select fields?

    I'm using an order form where clients may update quantity in a text field.

    To make it more customers friendly, I would like to have the field with the select format.

    But doing so in the form, the javascript is not doing anymore.

    Can anyone have a look and let me know what to change in the script to have it working with select fields in place of the text fields?

    Thank you

    Code:
    <html>
    ...
    See more | Go to post
    Last edited by Niheel; Jan 25 '11, 02:05 PM.

  • How to use option group (checkbox) to change calculation in textbox

    I have an option group with 2 checkboxes :
    MtbAge - option value = 1
    RoadAge - option value = 2

    The textbox where to display MtbAge/RoadAge is called = currentage

    if you select MtbAge it must use
    Code:
    =Format(DateSerial(Year(Date()),12,31)-[Birthdate],'yy')
    to calculate

    if you select RoadAge it must use
    Code:
    =DateDiff("yyyy",[Birthdate],Now())+Int(Format(Now(),"mm
    ...
    See more | Go to post
    Last edited by NeoPa; Jan 8 '11, 03:22 PM. Reason: To show the pic

  • Calculating and recording on the table from 12 fields in form

    Hi,

    I am new to Access and I seem to have run into a conundrum. I am currently using Ms Access 2007. I have a table setup with 12 fields and form with 12 fields which is corresponding to the 12 fields on the table.

    The 12 fields on the form are combo box with setting
    Row source: 1;"Yes";0;"No "
    Column Count: 2
    Column widths:0";2"

    If I am correct, this allows the...
    See more | Go to post

  • Creating Access DB based on FileMaker DB - Calculated Fields Question

    I am new to Access 2007, a former FileMaker Pro database user.

    I am trying to replicate some functionality that was available in the FM DB, which involved Calculated Fields in one of the Tables.

    The Calculation would evaluate the dates in some of the other fields in the table and return a numerical result. Filemaker used a Case calculation.

    I need to replicate this functionality in my new Access 2007 DB...
    See more | Go to post

  • jenniferhelen
    started a topic query calculation problem

    query calculation problem

    I am having a problem with a calculation in Microsoft Access. I am trying to add two numeric columns, however the result I am receiving is the data is being concatenated. I am using the following formula: newField:([field1]+[field2]). If field1 contains 567 and field2 contains -98, my result is 567-98 instead of 469. I have performed simular calcualtions many times and I am going nuts trying to figure out why this won't work. I appreciate...
    See more | Go to post
Working...