Software

Ask something
Discussion Locked

Access Report Problems

0 helpful
11 replies

by stuart.odwyer

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a form with a sub form within it for my companies purchase orders that I'm creating at the moment in microsoft access 2003. Everything was working fine, but now when I go to preview report the data I have input into the sub table duplicates on the report. Now I could just hide duplicates, but this problem also means my total at the end of the report is double what it should be.
If anyone has any suggestions please help. Its been a good 6 years since of used access and I'm really stumped.

11 replies

by deepsand

The "Discussion" forum is for matters of general discussion, not specific problems in search of a solution.

Post problems such as this to the "Question" forum, rather than the "Discussion" forum. There are those who specifically seek out problems in need of a solution, and that's where they go to look for such.

Additionally there are the benefits that:

1) The "Questions" forum provides for your feedback, by way of your being able to mark "helpful" responses as such. This does not necessarily mean that a given response contained the complete solution to your problem, but only that it served to guide you toward it. This is intended to serve as an aid to those who may in the future have a problem similar to yours, so that they might have a ready source of reference available, thereby perhaps obviating the need for them to repeat questions previously asked and answered.

2) The revised TR makes it quite difficult to find both "Discussions" and "Questions" that have not had a fairly recent post, owing to some functions comingling them in the listings. By keeping each type in their respective forums, it is easier for all to find what they are seeking.

by deepsand

replace your original post with a link to your Question, so that anyone who may come here later ends up in the right place.

Good luck.

by john.a.wills

What makes you think the duplication is only in the report, not in the tables?
Why are you using a subform to input data?

by deepsand

TR, and various members, have been attempting to get Questions posted to the proper forum, i.e. [b]not posted in the Discussions[/b] forum.

That effort is undermined by responding to such here with anything other than a post pointing them to the proper forum.

by john.a.wills

of those referring questioners to the questions forum, but since the revamp a few months ago there has been no separate questions forum, alas. This questioner should have marked his question as such, of course, but it doesn't make much difference with the present dispensation.

by deepsand

1) Those who specifically seek out items in the "Question" forum will not seek those improperly posted as a "Discussion."

2) The "Discussion" forum does [b]not[/b] have the "Helpful" feedback mechanism that is present in the "Question" forum.

3) Those with a problem who first seek out any previous advise re. a problem such as theirs in the "Question" forum will be deprived of any helpful advice that may have been posted in the "Discussion" forum.

While you may have given up your efforts to get people to post to the proper forum, TR and several other members have not.

This discussion is closed to new replies.