troubleshooting Question

Access report shows duplicate data

Avatar of urjudo
urjudoFlag for United States of America asked on
* msaccess reportsMicrosoft Access
1 Comment1 Solution20 ViewsLast Modified:
Hi Experts,
I'm working on a computer inventory report on office 365 Access 2016.  I have a question about how to separate a field in order to get the correct Asset# and serial# under the category.
my table has Asset#, serial#, assigned to & Category.

here is my table look like

Asset#              Serial#               AssignedTo                 Category
12345                6785436           Doe, John                     Laptop
12365               yu5677               Doe, John                     Docking Station
12349                7865567            Doe, John                     CPU
12348                tt788999            Doe, John                    Monitor

what I wan to do my report is: (I only need to show the Laptop & Docking Station for right now)
here is what I want my report look like:

Employee Name:  Doe, John

Laptop Asset# :  12345

Laptop Serial#:    6785436

Docking Station Asset#: 12365

Docking Station Serial# yu5677

I create query, the query list all the info but when I do the report, I can have them by itself, it shows double on each Asset# and Serial# because the Laptop and DockingStation are under the category, how do I separate them so that they can show once and also match the if it's Laptop then capture the laptop info, if it's docking station then shows the docking station associate with the name of AssignedTo.

Any help will be appreciate!

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros