Inventory Available vs not - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Inventory Available vs not

Christopher Davis

3 years ago

Hello,
I have completed all of the beginner lessons and the first expert lesson. I have run into a wall that, to me, seems like it should be easy but I can't figure it out.

I have a data base I build for keeping notes on my bee hives. It tracks what hive # is located at what apiary, what equipment is part of that hive, and notes on daily inspections.

I also have a basic table that has an inventory of bee hive components I own. This is a complete quanity list.

I'm trying to take the each items in the columns in my notes table such as "medium super" or "Inner Cover" Count the times they appear and then have them subtract from the total quantity that I have in my equipment table.

I watched the rental inventory video and see a comment from Richard saying this gets tricky when its not just 1 item of each type. Any suggestions, video links, or courses I should look at on here would be much appareciated. I'm starting to think I'll need to build a few dozen queries to make this happen which seems less than ideal making me think I'm wrong about that. Thanks again for any advice.

	Alex Hedley @Reply 3 years ago
TH: Inventory Search: Inventory

Christopher Davis OP @Reply

3 years ago

Thanks for the response Alex. I have watched these and I'm actually using part of the inventory data base I built alongside watching these. I'll rewatch them and see if I can figure this out. The way I understand how inventory in this video works is its added or subtracted from a 'form' when you add or sell inventory based on you adding items to the from/list and then a record set update.

I want to be able to assign equipment to a location via a form and have a query, query said linked list, for how many, lets say 10 Frame Lyson medium supers, are in that list, and then deduct that number from the overall inventory number. I could then build a report that shows me how many unique items are in storage vs in the field somewhere.

Since I want to see the total that I own, but split up between whats in the storage shed and whats in the field. I don't think I can use the same logic that is in the inventory video and records sets. I'll go back and relook though for sure.

Christopher Davis OP @Reply

3 years ago

For anyone interested and reading this. It appears the solution to my problem was to create a SKU for the equipment I own and store that value in the table rather than the equipment name. This allow for the query to count unique values in each cell. The unique value seems to have been my issue all along. If I run into another issue I'll try to update here for anyone that comes along this issue too.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View