Search results

I was just wondering if there was no reply because no one tried to work with the database I attached in the immediately previous post, or because no one was able to get it to work the way suggested in prior messages in this thread. Thanks.

Hi and thanks for your replies. I have tried all of the suggestions, as best I understood them, but was unable to get the desired result, except when I created a new field in the tblMembership and copied redundant data to it from the tblMembersTrans via the frmMembership which has all fields...

Hi Bob: Thanks. I tried doing the above several times and several ways; probably, I messed up, or possibly, if I select a year and there is no transaction record for that year, it won't show the data that I want. Anyway, the point is now somewhat moot because I used a less elegant way to...

Hi Glaxiom: Thanks. I tried that but it still does not work when I am trying to show which members had no transactions, but only for a specified year or years. I already have an old query in the database that shows members who have never paid anything, ever (all years). I imagine that the...

Hi: I'm sorry but I don't know what those terms mean. What is a left join and how do I do that? Thanks

Table 1: tblMembershp Table 2: tbl MembersTrans Relationship: I am a volunteer for a small non-profit organization. I maintain membership records and am also a member of the board of directors. Everyone is an unpaid volunteer. I want to generate a query (MS Access 2007) that will show...

Hi vbaInet: First, before I go on, I want to thank you very much for taking the time not only to review my sample DB but also for the detailed instructions that you prepared. Besides the fact that I really have to read much more to learn about the proper use of databases (up to now I have only...

Hi vbaInet: I revised both tables, in the main table, Membership, I used autonumber (ID) because that is the only field that can't have duplicates. In the Type (that is the type of membership), I already had the single field in that table, namely "Type" already designated as the primary key...

Hi vbaInet: The problem is that since I added the combo box, when I create a query, I get the above error message for the field that the combo box is related to. Please open the attached sample datbase (in the zip file) and click on this query: TEST-Membership Query-2010-TYPE. When the error...

I have attached a test version (only a few test records and various forums, queries, etc. deleted) of the database causing a problem. I'm sorry for such a long post; however, it is the only way I know to adequately explain the problem. Using Access 2007, I created two similar combo boxes...