I developed a Donation Retrieval Information System, DoRIS for short, which gathers data for and gives donors date-specific reports to aid in filing taxes. (Updated monthly; reports run annually).
The search form uses parameters to retrieve records in a donor report (donor, start date, and end date). I've added a list box for a third parameter in the search form (the year of the date field) but need help to figure out how to implement.
Selecting only the year would save a couple of steps in running the annual report, although I need to keep the date parameter for other querying needs (for example, by month). How do I add this final parameter?
Thx in advance for any help you can provide.
Kevin Robertson
@Reply 4 years ago
You could use the Year function to get the year of a certain date.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.