1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Help PLZ before my brain finally oozes out of my ears!

Discussion in 'Microsoft Office Specialist (MOS)' started by Greebo, Apr 16, 2004.

  1. Greebo

    Greebo Byte Poster

    182
    0
    21
    Plz someone help me

    Done all the design etc for a Access Database I'm doing for my Assignment. Everything works and my tables, forms, queries are good.......yet

    I'm TRYING to find out the amount of people that have registered for more than one thing and I just don't get it :cry:

    I can see them all (as in one person showing 6 times) but I want to be able to say this one person has registered for 6 things :roll:

    Plz help me

    Still got other assignments to complete but I was hoping to finish this one (was hoping to sort it last night but gave up at 02:00 and went to bed) :eek:

    I'll sit and wait in hope :)
     
  2. SimonV

    SimonV Petabyte Poster Administrator

    6,616
    149
    228
    I'm guessing here, I think you may need to use the totals funtion in your query.

    Here this may help:
    http://www.fontstuff.com/access/acctut04.htm

    Let mek now if thats what your after.
    :D
     
    Certifications: MOS Master 2003, CompTIA A+, MCSA:M, MCSE
    WIP: Keeping CF Alive...
  3. Greebo

    Greebo Byte Poster

    182
    0
    21
    :lilangel Is wot u r :cheers :thumbleft
    :iluvcf :yep
     
  4. SimonV

    SimonV Petabyte Poster Administrator

    6,616
    149
    228
    I'm guessing from your reaction that didnt help :( , sorry I tried my best...... :tongue
     
    Certifications: MOS Master 2003, CompTIA A+, MCSA:M, MCSE
    WIP: Keeping CF Alive...
  5. Greebo

    Greebo Byte Poster

    182
    0
    21
    Just wished I'd have asked last night :oops: Would have saved me alot of stress :x

    Thanx so much for making my day :D YIPPIE :D
     
  6. AJ

    AJ Administrator Administrator

    6,771
    102
    221
    Looks like another satisfied customer. Perhaps we should have him stuffed?
     
    Certifications: MCSE, MCSA (messaging), ITIL Foundation v3
    WIP: Looking at doing ..................

Share This Page

Loading...