Access Help, need to convert from excel!

I need help doing certain functions in access, that I was able to do in excel. I'm not familiar with the differences in languages so please bear with me. I need to do a sum if and a modified version of vlookup which would also delimit where there are multiple values which match the criteria. This is unnofficially called "vlookupall". See bottom of page for a sample. I need to apply this to a query/ queries in an access database for work. What is the best way to go about this?

Thank you for your help!!! So much!

-------------------
What have i tried?

I think dsum is used for sumif, but i'm a little unclear on how the syntax works, even after reading. An example would be great.

I tried applying dlookup to my query, but i was unable to figure it out. Also I run into the the issue of needing it to delimit multiple matches for criteria into a single cell.

------------ This version does not seem to delimit! ( at least not as far as i can read)

Please Login or Register  to view this content.

Your code is Excel code, how does that fit in with your request? I though you were working in Access. If you provide an example of your table and what you want to get from it, I can give you an example of how dlookup and dsum work. That said, if you are trying to return multiple results, you should use a query instead.