Report - Microsoft Access Forum - Computer Learning Zone


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Report

Mark Desens

8 hours ago

Hi Richard and guys. a few days ago i was asking for help with a report. Richard Blackwell helped. Thanks for sharing about the invoicing. Now i have a little different problem but still the report. I am getting multiple records in the detail and i only need one, any suggestions. I am watching the video still on invoicing. I am missing something here. Richard i saw your video and saw that you had duplicates until after you put some things in detail and page header.

	Alex Hedley @Reply 2 hours ago
What are your JOINS in your query?

Mark Desens OP @Reply

8 minutes ago

Hi Alex in the tables there are 2 that have different data. One is for the contributions per month and the other is for the names and addresses. In both tables the names have their own ID to show who gave what in which month they gave. In the query the joins is the ID. the primary key is in the PeopleT. in the peopleT i where the ID I put in the properties no duplicates. But still they duplicate in the query. I am still working at it. I am watching the videos that Richard suggested to gain more info about it. Thanks.

Next Unseen

New Feature: Comment Live View