Should I use a query for this? If so, how?

  • Thread starter Thread starter Flopbot
  • Start date Start date
F

Flopbot

Any advise is greatly appreciated! I’m still pretty new to queries.

I am creating a volunteer database in Access 2003 and need something that
will allow me to quickly go back and review which volunteers worked at past
events. I’m only using this information as a reference, not to enter or
calculate data.

IMPORTANT NOTES:
~Some events repeat regularly: “Specialistâ€, “Officeâ€, Halloweenâ€
~Some events never repeat: “Fundraiser 2008â€, “Exhibit Opening 2008â€
~Each single event may have multiple volunteers.
~When an event repeats, it may have different volunteers each time.


My first question: “Is a query the best option?â€

My second question: “If so, how should I do it?â€


I’ve already created a basic query with the following fields:

[Event/Program], [Date Worked], [Volunteer ID], [First Name], [Last Name]


What I want my query to do:

[Event/Program] ~ Group together similar events while excluding those
labeled “Specialist†or “Officeâ€.

[Date Worked] ~ When there are similar events, display the most recent first.

[Volunteer ID] ~ Just return results.

[First Name] ~ Just return results.

[Last Name] ~ Just return results.
 
"How" depends on "what"...

How to design a query depends on what data structure you have.

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
A query is absolutely correct. All you need to do is click on the TOTALS
button in the query window (next to the drop down list with ALL in it). This
enables the key functions (group by, count, etc.) then choose GROUP BY for
all your fields (make sure the fields are in the order you want to group by)
and you're pretty much done. If you want to filter out certain events, just
add them as criteria (e.g. <> "Office").
 
Back
Top