Search results

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...

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

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...

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.

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

Fixed it and reattached.

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

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...

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...

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...

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

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...

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

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

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...

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!!!

Yes!!! This is it....

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...

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...

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...