General discussion


Avoiding repeated data in access

By Markolino ·
I have a download consisting of Customer Order (CO) data and Purchase Order (PO) data. For each PO, there are multiple COs. Each PO and each CO have a quantity and other related info associated with it. Because of the many-to-many relationship, when the data is downloaded and imported into access, a single PO# and related info will be repeated as many times as there separate COs associated to it. Therefore when I wantto sum PO quantities, Access will sum each occurrence. What's the way to avoid that?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Avoiding repeated data in access

by tech In reply to Avoiding repeated data in ...

I'm not sure if this is the kind of answer you or looking for or not, but this will give you an accurate count of your PO#'s. I'm assuming you are summing in a report, so if you add sorting and grouping, and a group header for your PO#'s, and do your sum in the header, it will only count each PO one time because it will only show each PO once.

If this doesn't answer your question, let me know, because I have some other ideas, this was just the simplest one.

Related Discussions

Related Forums