Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
subreport duplicate data
This is the best I could do on table data.I deleted all the data that was null or zero to save space in the post. tblmember Member # Name Address City State Zip Code Monthly Dues Rest & Bar Credit Current 1 Months Balance1 Balance2 Dues NewBalance 1 a abcd Silsbee TX 77656 $85.00 $10.00 $95.00...- jnh127
- Post #7
- Forum: Microsoft: Access Reports
-
subreport duplicate data
This is a sample of the report. The spacing was changed when I posted it, but I think you can decypher it. Statement Statement Date - 4/6/2005 Member # 1 Silsbee Country Club, Inc. P.O.Box 982 a Silsbee,Tx 77656 abcd Silsbee TX 77656 Balance Brought $280.00 NOTICE -...- jnh127
- Post #6
- Forum: Microsoft: Access Reports
-
subreport duplicate data
This is the sql code for the recordsource. SELECT tblmember.[Member #], tblmember.Name, tblmember.Address, tblmember.City, tblmember.State, tblmember.[Zip Code], tblmember.[Vol Contribution], tblmember.[Monthly Dues], tblmember.[Cart Stall Rental], tblmember.[Handicap Fees], tblmember.[Locker...- jnh127
- Post #5
- Forum: Microsoft: Access Reports
-
subreport duplicate data
dataleft1 dataright1 dataleft2 dataright2 dataleft3 dataright1 duplicate dataleft4 dataright2 duplicate dataleft5 dataright1 duplicate dataleft6 dataright2 duplicate There should only be 2 entries on the right. The last four are duplicates. For some reason...- jnh127
- Post #3
- Forum: Microsoft: Access Reports
-
subreport duplicate data
In a subreport, I have a column of data on left from a table, and a column of data from different field and table on right. If there is 6 entries of data on left and 2 on right then data on right will print duplicates until there are 6 entries. The 6 and 2 entries can be any amount and the same...- jnh127
- Thread
- Replies: 7
- Forum: Microsoft: Access Reports
