Search results

Thanks! Appreciate your help, that worked :)

Oh, I see. Ok. Assume 2015 entered for the parameter, then the results would be: A-AVC-SCA / 1 / 12 A-CM-EFK / 2 / 47 A-FZ / 1 / 12

I think this is what you're looking for, see the attached screenshot of part of the table (tblHoursWorked). Field names (I realized that some of them were cut off) are HoursID, HoursWorked, MonthWorked, YearWorked, FiscalYear, JobCodeLookup, NamesIDFK -- NamesIDFK is the identifier for the...

I'm trying to write a query to get a count of Volunteers under a certain Job Code for a given year - problem comes in that a single Volunteer may record hours multiple times under a Job Code in a given Fiscal Year. I can't seem to get "Unique Values" to work, so I'm hoping for some assistance...

Wow! That... worked. So I don't need to specify which NameID, it's OK that they are the same? Thank you so much :)

This seems to be one of the most common problems but I can't seem to figure mine out, even with all the posts and responses, so I'll post mine here and see if you guys can tell me what to do :) maybe then I can keep my hair. :banghead: =DLookUp("SumOfHoursWorked","qryHoursWorkedAllTime","NameID...

Like the one I attached the screenshot of? I got that working, but wasn't able to figure out how to sort the data by month and year. Now that I think about it, I have to filter out the previous years, too, and then re-collect that data for the previous years field. More thinking needed, I guess.

To my other point, is this even the best way to go about this? I have read a lot of things that make me wonder if using domain aggregate functions is a good idea, or if I would be better off using the subform/query and trying to figure out how to sort it meaningfully.

Ok, when I get to the office I'll try that again. Seems like that's what I had at first and I got a syntax error, maybe I missed a quote. Thank you.

Any chance you could explain? Obviously I've seen those sorts of examples and already done it wrong. Not sure what needs to be different. I had the table name in there separately once and it gave me an error.

Ok, I'm not sure if I'm approaching this the right way or not. I've never done anything like this with Access before and a lot of the jargon is very unfamiliar and hard to sort through. I have a volunteer information database, and I am working on the form that will show the details of each...

Hours are reported monthly. So, while we might get the date an activity is performed, more likely we will get "30 hours in the month of June," if it's an ongoing activity, or "8 hours at day-long event on June 3rd". The person who came to the daylong event MIGHT volunteer again in June, but it...

Ok. Take a look at this, if you would, and tell me if it's more what you were saying before. I'm not sure I joined the Hours table correctly, my old one had two Primary Keys, does that one need two as well? Stephanie

So as I think through this, maybe I just get rid of groups altogether as an idea, and when we get a group registered, since I'm still getting their names, just make sure I have who is under 18 (since that's the only group info that's relevant) and enter them as individuals with just less...

Job and Project are, I guess, really the same thing. A Job is just a Project with one person. The job code is a letter code that's made up of a letter for the division, then an abbreviation (there's an existing list of these codes) of the job title. For example the dogwalker one is I-KEN-DW, for...

It helps but gives me more questions :) So... the short answer is no, the individuals do not always belong to a group. Sometimes they do, but that has not been tracked in the existing Excel system. The members of a group only exist in the paper in the filing cabinet. It has to do with how much...

Well, I had started out by putting the Emergency Contacts and the NPS Employees in the same "Names" table, but I got too confused so I split them out. There are "Group" and "Individual" volunteers, and a Group will not have all the details that an Individual does. That's the main reason, in...

Thanks for the advice and the links - I have done a couple of tutorials so far, I learn best with videos though and our internet here in the wilderness (Denali National Park) is not always the friendliest for watching/hearing them well. I tried to attach a screenshot of my relationships table...

I am working as a volunteer this summer, and one of my projects is moving our database of volunteers from years of Excel spreadsheets to a database structure. I've worked in Access before, but it's been some years, and some versions, and none of my projects were as complex as this one. I've...