Recent content by reknox

Thanks but I stated that was done in the original post.

Using Access 2003, have query that sorts by last name and first name correctly. The report that was designed using the query won't show the name (first or last) if it is a duplicate. The report sort/group box has the name fields. The table is indexed and allows duplicates. Any suggestions...

Yes what you gave me worked. Thanks a lot. I'm always amazed at how simple things turn out when it seemed so difficult in the beginning. Will you elaborate a little on your last suggestion regarding the 4 parts. Which one covers the null value?

I read the help as you suggested but it's way over my head. I can get a 0 with using the following in the report control: =IIf(IsNull([Qtr2]),"0",Format([Qtr2],"Currency")). Even though I set the format control as currency and decimal as 2, unless I add it as shown in the expression, it won't...

I now need help with a report. My last post was in the query section related to joining several queries and getting the correct result. By the way BrianWarnock, I am taking your advice on the look up field in the table and removing it. I had read the pros and cons about this on several sites and...

Apologies Brian - no slight intended. I don't recall seeing your post until now. I was just so happy to have someone look at the db. The date field shouldn't have been in the query; I actually thought I had removed it. Always appreciative of getting suggestions cause I have lots to learn.

Thanks a lot. I know about summing so hopefully won't run into many more hurdles. This has truly been a great learning experience.

I hope I sent the correct file as I have several copies with which I have been experimenting. The query in question is AllQueriesJoined. You can see the problem immediately when opening. To re-state, there are two tables and the goal is to end up with a report which lists contributions made each...

SELECT T_Contribution.MemID, T_Members.Address1, T_Members.Address2, T_Members.MemCity, T_Members.MemSt, T_Contribution.ConDte, T_Members.MemZip, [Qtr1 Query].Qtr1, [Qtr2 Query].Qtr2, [Qtr3 Query].Qtr3, [Qtr4 Query].Qtr4 FROM ((((T_Members INNER JOIN T_Contribution ON T_Members.AutoMemID =...

Back again. Got the queries working with the correct data under the appropriate column; however, there are duplicate lines according to the number of records per name (field). Does this have to do with the join. This is using a left join. If not, what. Thanks.

Hold up; you both got me thinking and I believe I have resolved it. I'll finish testing tomorrow as it's late where I am. Thanks for your help.

No. It doesn't group by name; each name is duplicated or even appears several times. (I forgot earlier to say that the name is linked to MemID in the query). Some names and dates appear in the query that shouldn't because it's not in the where clause for the particular query. I wonder if I've...

Taking advice from another post, have created 4 different queries, named Qtr1, Qtr2, Qtr3 and Qtr4. Need help with getting correct results. Want Qtr1 to be the sum of ConAmt where dates > =1/1/2009 and <=3/31/2009. If I can get help with Qtr1, I can do the others. Fields included in all queries...