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

Discussion in 'Microsoft Office Specialist (MOS), Office 365' 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
    Honorary Member

    SimonV Petabyte Poster Gold Member

    6,651
    180
    258
    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
    Honorary Member

    SimonV Petabyte Poster Gold Member

    6,651
    180
    258
    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 01000001 01100100 01101101 01101001 01101110 Administrator

    6,897
    182
    221
    Looks like another satisfied customer. Perhaps we should have him stuffed?
     
    Certifications: MCSE, MCSA (messaging), ITIL Foundation v3
    WIP: Breathing in and out, but not out and in, that's just wrong

Share This Page

Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.