Search results

I am creating a project for school. In this project I have a database which contains tables for each ingredient category/vendor for a group of restaurants. I have queries which show the data from like categories but different vendors. Is there a way make a checkbox which can allow the user to...

I have a Database which is linked to several spreadsheets. I use an append query to move the sheets into a table while also filtering unwanted rows. What i would like to do is add a two fields to each table and auto-populate those fields with a specific text (dependent on which sheet the table...

I asked a question similar to this before but the data I am working with is a bit different than i first thought. I have several tables which are linked to excel sheets which have supplier quotes for differing categories. I have created a query which takes only the supply name and supply price...

I am attempting to create a database which will import quote sheets which are received in excel sheets from suppliers. Each one of these excel sheets are categorized i.e. Dairy, Protein etc. The issue is that some of these sheets contain subcategories i.e. Dairy will have the subcategories of...

Hello, I am working on a school project in which i need to create a database for a restaurant chain. right now i have two table in which i input quotes for a specific category of ingredients from two different suppliers. I want a query which can identify which supplier is the overall cheapest...

Hello, I am creating a database which identifies the cheapest supplier for each ingredient. I then need the identified cheapest price for each ingredient to populate a table which shows which ingredients are in which item. I created a query which can identify which vendor sells each ingredient...

Hello, I'm pretty new to Access so really need help. I am making a a database for a restaurant which needs to be able to select the cheapest vendors for all ingredients. Quotes are received weekly from three seperate vendors. I cannot figure out how to get access to identify which vendor is the...