Search results

Thanks so much for your response, Rain. I used your expression and it works wonderfully, although I can't query any criteria based on it. What I did was create a query with that expression that makes a table, then I created a 2nd query based on the query-created table and was able to query my...

My expressions is as follows: =IIF([RenewalDate]>0, [RenewalDate]+365, IIF([RenewalDate], "", [OriginalMembershipDate]+365)) My critieria is to find all the ones who need to renew within a certain month, as we send out monthly solicitations to those who are expired at that time. My...

Thanks for all the great responses. I created an expression in a query, but the problem now is that the field I created the expression in does not recognize my criteria?

Let me start by saying I do not know how to use SQL or VB so all I am doing is within Access itself. I have a Membership Database created in Access. The main table, Members Table, includes a field for Next Renewal. The Next Renewal Date should be one year from the last membership update. To...

I have a Membership database which I maintain for a local non-profit environmental group. The db has many tables, but the two main tables are the Members Table (demographic data) and the Contributions Table (shows each contribution made by a member). One member can have multiple contributions...