How to create a query
Operating system version
Mac OS X (Lion)
Description of the issue
I just moved from PC to Mac and imported an AccessI database of the membership of the local retired military officer club (using Excel as the import tool). I can't figure out how to do queries. Here's what I want to do:
1. Using a Dues field (a year figure) show those who have 2012 in that field as 0pposed to 2011.
2. Using a Service field (Army, Air Force, Navy, Marine Corps) be able to show just those from one of the services.
3. Show just name, address, city, zip (4 separate fields).
Membership changes (new, died, address change, etc.) occur all the time. After doing one of the above, I'd save as an Excel file to send to the Board members.
I'd appreciate any help. I'm brand new to FileMaker so would like specific instructions.