User Tag List

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Help Required with Microsoft Access

  1. #1
    Regular Member Merick's Avatar
    Join Date
    Mar 2007
    Location
    Wigan & Preston
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    StatsVehicle Info
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Help Required with Microsoft Access

    Good Evening..

    I'm having fun with Microsoft Access.... is anybody any good with it?

    Here's my problem..
    I have the form below..



    The top half is a subform where the "Extended Price" is calcuated by this "=Nz([UnitPrice]-([UnitPrice]*[Discount]))"

    The problem i'm having is that since i made it work out the discount.. the "Order Subtotal" no longer works... I tried "=Nz(Sum(Forms![Order Details Subform]!Price))" But it just gives an error..... anyone know how to get it to work it out? It worked when the "Extended Price" was manually entered.

    It's been driving me nuts all day.

  2. #2
    Regular Member um20's Avatar
    Join Date
    Mar 2007
    Location
    Doncaster
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    StatsVehicle Info
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Blimey. I dare say I could give it a go in person, but not standalone as it were. I'd just keep trying things, you'll probably stumble across it eventually

  3. #3
    Regular Member Merick's Avatar
    Join Date
    Mar 2007
    Location
    Wigan & Preston
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    StatsVehicle Info
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I've always hated Access, even more so when it comes to writing formula's.. this was supposed to be a quicky database but it's now entering it's third day of setup.. most of which i've spent trying to get this damned formula to work.

  4. #4
    Regular Member MysteryElite's Avatar
    Join Date
    Feb 2007
    Location
    North Somerset
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    StatsVehicle Info
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Going by the text and column name, would that not make the sum:

    "=Nz(Sum(Forms![Order Details Subform]![Extended Price]))"

    ?

  5. #5
    Regular Member Merick's Avatar
    Join Date
    Mar 2007
    Location
    Wigan & Preston
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    StatsVehicle Info
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I named it "Price" in the attributes but the label on the subform is "Extended Price" Tried both anyway and neither works.. I'm tempted to start again from scratch.. i did this one using a template and changed it but it's a pain in the backside. At least if i start from scratch i know exactly what is set to do what.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Ford vs Microsoft
    By tony-1977 in forum Comedy & Humour
    Replies: 4
    Last Post: 4th February 2012, 19:03
  2. Microsoft Exchange
    By T4M in forum General Chat
    Replies: 15
    Last Post: 9th July 2010, 13:30
  3. Microsoft Excel help required
    By siadwel in forum General Chat
    Replies: 7
    Last Post: 19th October 2009, 18:05
  4. Microsoft Word???
    By OPC in forum The 'Off Topic' room
    Replies: 3
    Last Post: 3rd May 2009, 13:26
  5. microsoft
    By jonno_07 in forum Comedy & Humour
    Replies: 0
    Last Post: 26th May 2006, 23:28

Visitors found this page by searching for:

Nobody landed on this page from a search engine, yet!

Bookmarks

Posting Permissions

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