Results 1 to 6 of 6

Thread: Hi can you help

  1. #1
    Join Date
    Dec 2008
    Posts
    4

    Hi can you help

    Hi I wonder if you can help me with a problem I have with my database. its nearly midlnight and I need it for tomorrow so I will be up all night.
    I would really appreciate if you could help me resolve a problem I have.
    I have made all of my database except for a small part which I cant crack due to lack knowledge.
    The form I have has 10 different line price boxes to add up. cant get the sub total to add them all up.
    The price for any item is randon so I cant use a price table. the price's are completly random entries into the price field. and the invoice form needs to add on a VAT of 15%
    Problem 2
    I need to look at the relationships so that when an order is input on the sales form, it saves a copy for print or storage in the invoice table.

    I would be willing to pay for your services but the most I have to offer is 50
    Im desperate and like I said earlier I will be awake until I can resolve these issues.

  2. #2
    Join Date
    Dec 2008
    Posts
    4

    Hi can you help

    Hi I wonder if you can help me with a problem I have with my database. its nearly midlnight and I need it for tomorrow so I will be up all night.
    I would really appreciate if you could help me resolve a problem I have.
    I have made all of my database except for a small part which I cant crack due to lack knowledge.
    The form I have has 10 different line price boxes to add up. cant get the sub total to add them all up.
    The price for any item is randon so I cant use a price table. the price's are completly random entries into the price field. and the invoice form needs to add on a VAT of 15%
    Problem 2
    I need to look at the relationships so that when an order is input on the sales form, it saves a copy for print or storage in the invoice table.

    I would be willing to pay for your services but the most I have to offer is 50
    Im desperate and like I said earlier I will be awake until I can resolve these issues.

  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    problem 1
    in the footer of the report/form put a text =Sum([feildname]) or =[feildname]+[feildname]+[feildname]

    vat = (([newly added text]*.15) + [newly added text]) some like this

    problem 2
    question what the differance between sales form and invoice table
    why just add a feild to the sales form invoice (T/F) or even beater add a invoice date feild if 'invoice date' = null then not invoice
    then what i do is create a payment table which only has invoiceID, amount Paid,date paid then you can write a outter join to show how has not paid there invoices.
    Last edited by myle; 12-08-08 at 21:15.
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I guess he fell asleep ^^

    Is this homework??
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Dec 2008
    Posts
    4
    hi sorry not asleep was racking utube and trying to build expressions to work out the prices.

    so yeah im still here.
    can i email this to ya my head is shot, been trying to solve this for days.

    Regards
    mark

  6. #6
    Join Date
    Dec 2008
    Posts
    4
    I tried =[item Price 1] + [Item Price 2], all the way upto 10 works great on the first record, then stops working.

    Thanks
    mark

Posting Permissions

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