Hi All,
First time poster, relatively new access user.
Currently at my job we receive a handwritten daily inventory sheet with about 60 different tank levels on it. We have another sheet that we use to handwrite the material movements from one tank to another. I'm attempting to digitize this with an access database.
I have two form and two tables, one for the inventory sheet and one for the transfers. The inventory sheet has every tank as a field.
I would like to be able to create a query that will link material transfers (which will be posted in same field), to the specific tank the transfer came to/from.
The problem i seem to be running into is that since all of my tanks have their own field in one table, I do not know how or if its possible to make a query to select a particular field (ie tank). I've watched youtube videos and understand how to add criteria to a field, but can you have a user input the desired field for a query?
I would ultimately like to query the particular field from the inventory table and then the items relating to that field from the other table.
Thank you for your help!
First time poster, relatively new access user.
Currently at my job we receive a handwritten daily inventory sheet with about 60 different tank levels on it. We have another sheet that we use to handwrite the material movements from one tank to another. I'm attempting to digitize this with an access database.
I have two form and two tables, one for the inventory sheet and one for the transfers. The inventory sheet has every tank as a field.
I would like to be able to create a query that will link material transfers (which will be posted in same field), to the specific tank the transfer came to/from.
The problem i seem to be running into is that since all of my tanks have their own field in one table, I do not know how or if its possible to make a query to select a particular field (ie tank). I've watched youtube videos and understand how to add criteria to a field, but can you have a user input the desired field for a query?
I would ultimately like to query the particular field from the inventory table and then the items relating to that field from the other table.
Thank you for your help!