Search results

  1. P

    How do you combine this into one?

    I attached a database with 2 tables. I'm trying to give a roster to the supervisor of each team (Beer Garden Super, Vol Support Super, Hospitality Super), that has everyone on their team. I don't want the primary table to have multiple listings for the same person. (note... I have 750...
  2. P

    TShirt Query, (newbie!!!)

    Finally getting back to this issue. Thanks for the suggestion. I will try that!
  3. P

    TShirt Query, (newbie!!!)

    OK. I got it to work, but it's still including the withdraw team. When I tried to add it like you did on the ice team <> "withdraw" it comes up with an error. I'm not sure how to add an additional condition like this. I also added the "yes/no" field as you suggested so perhaps there is...
  4. P

    TShirt Query, (newbie!!!)

    When I pasted that SQL code in it returned nothing. I'm so lost. I'm attaching it again. Thanks for working with me. I'm buying a book on SQL.
  5. P

    TShirt Query, (newbie!!!)

    I'm attaching the database again but (NEWBIE)... and I don't know if this is what you meant by fixing my relationships.
  6. P

    TShirt Query, (newbie!!!)

    Fixed it and reattached.
  7. P

    TShirt Query, (newbie!!!)

    The supervisor gets his own from a different source, so just needs the info.
  8. P

    TShirt Query, (newbie!!!)

    Data Should be (or close to it...): 13 shirts total Orange, Beer Garden, "Beer Garden" 1 medium 3 XL Pink, Camp Host, "Volunteer" 2 Medium 2 Large Pink, Camp Marking, "Volunteer" 2 Medium Pink, Volunteer Support, "Volunteer" 1 S Green, Guest Services, "Jessicas Team" 2 XL Nothing on...
  9. P

    TShirt Query, (newbie!!!)

    Sorry about that. What I need is to know 1. How many shirts to order total. 2. How many by size, color, and what is printed. I'm struggling with excluding the ice team and those who withdraw without deleting their information. (maybe a second query without those first, to build on?). I...
  10. P

    TShirt Query, (newbie!!!)

    So I have much larger database (1200+) but am struggling to put together this query. I need to know how many t-shirts of each size, in each color, sorted by "print" and excluding withdraw. Because of the wordpress-download to excel-upload to access, and then ordering "more later," I'm stuck...
  11. P

    T Shirt totals

    OK... thanks for your patience if you were helping! I think I got it after more studying it! Thank you so much!
  12. P

    T Shirt totals

    I took this sample (which was almost perfect....) and I made some changes. If you look at it, the notable changes are I added 2 fields in the personnel table. First the "role" and then the "print." These are essential for the order since Staff (role) gets a blank (print) pink shirt. I'm...
  13. P

    T Shirt totals

    This is amazing! I'm working through how you did it. (I only work Thursdays).
  14. P

    T Shirt totals

    I will try that. Still trying to figure these out.
  15. P

    T Shirt totals

    Please note I have limited time in the office but need some help with this. I PROMISE to get back to this thread.... as soon as possible. I'm trying to figure out how to submit an order for shirts from a table that has name, size, and extra shirts. SIMPLE! I have to create a doc to send to...
  16. P

    Query for years of service

    This helped me a lot!!! I really appreciate the video especially! I realized I need to start over on setting up my database. I bought yet another book to explain the concepts behind Access. I love having this forum! Thank you again!!!
  17. P

    Query for years of service

    Yes!!! This is it....
  18. P

    Query for years of service

    I think it's similar to you in that the basics are definitely easier in Excel but because I am managing over 5000 volunteers each year, different teams they are assigned to, all their contact info, t-shirts, etc, there are many different issues that arise trying to separate them into different...
  19. P

    Query for years of service

    I think that is the result of how many people worked each event. I'm looking for the result of how many events each person worked (Luke worked 2 events, Sam worked 3 and Carol worked 2.) I REALLY appreciate you helping me... I'm such a novice! And no one to teach me outside of a million...
  20. P

    Query for years of service

    I'm trying to switch over from Excel so understanding is really the issue. I'm not sure where the years should go in what you are saying...
Top Bottom