Search results

That is something i was completely unaware of, but could be quite handy. is it possible to make a field named "category" and "supplier" have the data in the file name populate these fields?

Hi Doc, Right now i am working with 23 sheets. This number is also likely to go up. Unfortunately, all sheets seem to have slightly different formatting however they do seem to all have the same or at least similar fields, they just go by different names. There is no field in any sheet which...

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...

nice got it to work with all sheets into their own table with only the records i require. I am still a little unsure how i will prevent duplication of data being entered. Should I attach a date to for each time a record is appended?

Hi Ridders, Is this a process that can be performed automatically? I am not entirely sure how i "copy" rows into another table. and then how do i omit the rows i do not need? is there code I can enter which will filter rows which contain certain text? or no text at all? not sure how to approach...

My goal is that it all quote sheets would be in a single folder. When a new quote sheet is received from a supplier, it would be saved over the quote sheet which is currently in the folder. So when the database is opened, the database would automatically import all sheets which are in the folder...

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...

Great! got it to work. This project has a ways to go so don't be suprised to see my name on this forum again. Thanks!

Ahh got it! Sorry I am quite new to Access and did not know i would have to go into SQL. So now I have got all the prices for that one category of ingredients. There are several categories for which i will have to do the same. Is it possible to get my entire list of ingredients at their chosen...

I got a the query to work which shows the sum of both suppliers. I did this one table like you said. However i cannot get a query to work which shows only the min of the two. I would also need all the data from the identified cheapest quotes to populate future tables.

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...

Thank you so much! This is a school project and there is a long way to go on it, so don't be suprised if you see more posts from me. Thank you again for the help, hopefully i can become more self sufficient with this

Hi JHB, The price comes from a list of quotes given from suppliers.I did use the min function to return the lowest cost supplier for each ingredient. I have attached the database to this reply.

OK thanks for the help everyone. My apologies, this is my first time making a database. i attached an image of the table and query i made which contains the menu ID and which ingredients are contained within that menu item. However i still cannot figure out how to get the lowest prices which i...

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...

Ok great, thanks for the help!

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...