I'm a first time Access user but was requested to create an inventory list from my boss.
What I'm doing is having a database that has all the different inventory items and it creates an individual form for each item along with a picture of said item.
I'm also exporting the database into Excel to have a nice spreadsheet to look at that lists all the items we have. My problem is I would like to seperate the items by their location. So everything in location A wil be grouped together and so forth.
Is there a way I can have Access do this for me?