Results 1 to 5 of 5

Thread: Table update

  1. #1
    Join Date
    Feb 2004
    Location
    Ga
    Posts
    16

    Unanswered: Table update

    Hi All,

    Still very new to Access. I added a Sum function on my form to sum up values entered through the form. My Sum function works well on the form but the data is not showing on the table associated with the form. How do I fix this?

    Thanks in advance.

  2. #2
    Join Date
    Oct 2001
    Location
    Chicago
    Posts
    440
    Could you elaborate on your 'Sum function' and how you are using it.
    What field(s) are you summing up?

  3. #3
    Join Date
    Feb 2004
    Location
    Ga
    Posts
    16
    Basically, it's a table that keeps track of Liquor, beer, and wine sales. Values are entered from the form for columns(item, quantity, and total) i.e

    Liquor row =[LiquorQty]*[LiqPrice]
    Beer row =[BeerQty]*[BeerPrice]
    Wine row =[WineQty]*[WinePrice
    Total =CCur([LiquorQty]*[LiqPrice]+[BeerQty]*[BeerPrice]+[WineQty]*[WinePrice])

    The item and quantity row are being recorded in the table but the total column containing these values above are not showing in the table. I want all values entered recorded in the table.

    Thanks

  4. #4
    Join Date
    Oct 2001
    Location
    Chicago
    Posts
    440
    The item and quantity row are being recorded in the table but the total column containing these values above are not showing in the table.
    What is bound / unbound?

    Wine row =[WineQty]*[WinePrice]
    Total =CCur([LiquorQty]*[LiqPrice]+[BeerQty]*[BeerPrice]
    +[WineQty]*[WinePrice])
    row??

  5. #5
    Join Date
    Feb 2004
    Location
    Washington
    Posts
    49
    Why are you storing a computed value? Just store the fields needed for the computation and compute when reporting or on the form.
    Cathy

Posting Permissions

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