Dublicate pages in Reports

[nickfalk]

Hi there,



I am relatively new to Access and have created a very basic database. There is a form where users can fill in information on past projects that our consulting firm has taken on (e.g. date, contact, description, team members, field, sector etc.). The form populates a table which generates a report. The only problem is that the report displays each project twice. The database is extremely basic and there is no querying or anything complex. I was wondering if there was a simple way to stop the duplication from occurring.

Thanks

[JoeM]

You first need to determine why the data is being duplicated.
If you look in the table, are records duplicated?
If not, it is probably an issue with the Report design.
You would want to take a look at what the Control Source for the Report is (is it the table?) and take a look at the Report in Design View and note which section the fields are placed in.

[nickfalk]

Thanks!

The records are not duplicated in the table. Each selection type (field) in the report has its control source as a field in the table. Also all of the information is input in the detail section of the report.

It must have something to do with how I linked the report from the table.

Certain fields have multiple answers for example a project could have 2 or 3 different sectors (pulled from a draw down list).
Potentially this is the problem?

[JoeM]

Certain fields have multiple answers for example a project could have 2 or 3 different sectors (pulled from a draw down list).

Are you saying that you have some multi-valued fields in your table?
Those are an ugly, ugly thing and I avoid them at all costs! They will likely cause you much grief, like you are seeing here. Most programmers I know won't use them at all. They are also not supported by other relational database programs like SQL and MySQL. So if you ever grew too big and had to move the database to a more robust system, it wouldn't work.

You may want to check out some of this link, which discusses Multi-Value fields and Reports:
http://answers.microsoft.com/en-us/o...5556c80?auth=1