Avatar of urjudo
urjudoFlag for United States of America

asked on 

Access report shows duplicate data

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!
* msaccess reportsMicrosoft Access

Avatar of undefined
Last Comment
Avatar of urjudo
Flag of United States of America image

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo