By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,453 Members | 3,194 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,453 IT Pros & Developers. It's quick & easy.

Creating Report with two one-to-many relationships

P: n/a
I'm having some difficulty creating a report in Access and I need some
suggestions. My company issues "Return Authorizations" when customers
need to return products. A customer calls in and we provide the
number. The customer then returns items for a refund or for an
exchange. Here is the basic set up of the tables in question.



From my table setup, I have two one-to-many relationships to the
return authorization table. So far, I've successfully created a
report that will show 1 (and only 1) return authorization (RA) and
list all of the items returned and all of the items sent in exchange.
The only way I was able to do this was by creating a form where
someone selects a single RA# from a combo box. Using the RA#
selected, I run three different queries, and create a single report to
view all the information.

However, now I must expand on this and allow more than one return
authorization to be FULLY reported on. I'm having difficulty creating
a query to retrieve all of this information. Am I trying to do the
impossible? Can a report be created for a relationship like this?

I would appreciate any suggestions anyone has to offer.

Thanks in advance,
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies

P: n/a
starwars <no****> wrote:
Comments: This message did not originate from the Sender address above.
It was remailed automatically by anonymizing remailer software.

Folks, please ignore the above posting.

Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
Nov 12 '05 #2

P: n/a
"starwars" wrote
Hey Salad, why did you change your
nick from U N Me?

I'd wager it wasn't for the same reason that you change _your_ alias on a
frequent basis -- whatever his "nick", he isn't a troll.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.