1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

I need help please in Microsoft Access

Discussion in 'Databases' started by KingAnime, May 24, 2020.

  1. #1
    Hello everyone,

    I need help please in Microsoft Access.

    I did the Assignment, but I can't figure how to sum CommissionAmount in the CommissionReport.

    If there any other mistakes please let me know also.

    I have uploaded the instructions and the Databases in Mediafire because when I try to upload files in this topic it gives this message:

    The following error occurred
    The uploaded file is too large.

    Database.zip


    The download link is here.
    http://www.mediafire.com/file/qtdcs8bkdrzod7g/Database.zip/file
    Thank you.
    SEMrush
     
    KingAnime, May 24, 2020 IP
    SEMrush
  2. mmerlinn

    mmerlinn Prominent Member

    Messages:
    2,576
    Likes Received:
    508
    Best Answers:
    6
    Trophy Points:
    320
    #2
    No way that I am going to download a POTENTIAL virus.

    If Access is like most other MS crap, you should have a SUM() function or something similar to use for totaling cells, rows, columns, etc.
     
    mmerlinn, May 24, 2020 IP
  3. KingAnime

    KingAnime Peon

    Messages:
    17
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    3
    #3
    I swear there is no virus. I'm not the kind of person who does these things.
    If you do not believe me you can scan it.

    As I mentioned before I can't upload any files in the forum it gives this message:
    The following error occurred
    The uploaded file is too large.

    Database.zip
     
    KingAnime, May 24, 2020 IP
  4. sarahk

    sarahk iTamer Staff

    Messages:
    26,241
    Likes Received:
    3,867
    Best Answers:
    108
    Trophy Points:
    665
    #4
    Do you even attend lectures?
    You seem to struggle with the simplest concepts.

    I haven't used Access in years but I use a tool called SqlYog which has a query builder in it that looks similar and there should be an option called something like "aggregate function" and then outputs the required SQL. Play around with it until you understand what the different options do and when you'd use them.

    upload_2020-5-25_12-57-43.png

    and if I did I'd have to put access on my computer and yeah, nah, that's not going to happen.
     
    sarahk, May 24, 2020 IP