question forum

deepsand, i put the ACCESS 2003 question here to see if you were correct about it (and you were).
fwest32

question follows:

Access Report Problems
stuart.odwyer@...
03/22/07
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.

1. Suggest that you try the "Questions" forum.
deepsand
03/22/07

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.

1.1. Thanks
stuart.odwyer@...
03/25/07

Thanks for the advice I'll try the questions forum then.

1.1.1. You're welcome. And, since you're here as well, you may wish to ...
deepsand
03/26/07

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.

2. more information needed
john.a.wills@...
03/23/07

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

2.1. ???
deepsand
03/24/07

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

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

2.1.1. I was one...
john.a.wills@...
03/24/07

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.

2.1.1.1. It does make a difference.
deepsand
03/24/07

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 not 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.

2.1.1.1.1. wnat question forum?
john.a.wills@...
03/25/07

You are thinking of something that TR abolished months ago, alas.

2.1.1.1.1.1. The one accessed via the "Ask a Question" button.
deepsand
03/26/07

Silly rabbit.

Visit us at www.TechRepublic.com