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!