Search results

As I said before, I have created some mini databases to do simple quotes, and try my hand at queries with calculations. I got one of them to work for an external part as long as there is a metal. I have not figured out how to do the calculations if there is no metal involved. Also I have figured...

I know that changes were to be expected, but I did not expect something this big. I do not think that the metals database will be as difficult as my current one. and I have made some serious progress in my current DB by making the smaller databases. I appreciate your help. I will continue to...

VBA, Today my boss threw a monkey wrench in my work. I believed that the Metal Market Prices would be entered once a week in the current DB. My boss informs me today that he wants an employee to go in every morning and enter that days Price for Each Metal with respect to many different...

HI, I have been working on a database for over a month now, and my boss just threw a monkey wrench in my work. I believed that the Metal Market Prices would be entered once a week in the current DB. My boss informs me today that he wants an employee to go in every morning and enter that days...

VBA, I have been working on a few different databases, all of which relate to quotations but on a much smaller scale. I tried to make a database that would quote just an external part (I believe I have accomplished this). I then tried to create a database that would quote a part internal or...

I am learning Queries and currently all of my calculations are working properly. I fixed the problem previously mentioned.

In my first query I tried it on this solution worked fine, however in the next one I received an error "The SQL statement could not be executed because it contains ambiguous outer joins. To force one of the joins to be performed first, create a separate query that performs that first join and...

I will try this and let you know how it turns out. Thanks so much for your help.

HI, I have a very basic and general question. I have a database that has some one-to-many relationships. Is it possible for me to have no related record in the many side? I have a table "NewQuotationT" that is linked to table "NewQuotationPartT" and that table is linked to table...

The words vendor and supplier refer to the same data. the marketing team calls them suppliers, and the sales team calls them vendors. the spreadsheets do not have any of that information. each time one of the 4 initial spreadsheets is used the information is then saved in a folder on our server...

I had an idea to see if I could create a smaller version of my database that will quote one individual external part. this eliminates the assembly aspect, which makes it a bit more simple. I also had to add a few fields to my tables and one new table. I was missing a few things from the...

I understand that the task at hand will be extremely difficult for me to accomplish. I do have longer than one month. I have until my internship is over which is August 7th 2015. I can tell you that I will work my butt off to get this done in the time frame. My boss understands that there is a...

1. The pricing is different in the market that is used from precious to base metals. The company may use a different market, however the calculations and all are the exact same. 2. TBD is To Be Determined. Those are extra slots in case there is more than only the two precious metals involved in...

I would really appreciate that. Working on this database is my only job. I am at work 8 hours a day, and I am hoping to resume working on the database as soon as possible. I understand you are busy and I thank you in advance for taking the time to help me. I am not sure, but I think my biggest...

Are you thinking that starting over completely is the only way to go about this? Or do you think I could salvage some of my current DB and make edits?

Thank you so much. I am understanding and learning more and more every day between research and just experimenting. I look forward to your response. Thanks again.

1. Exchange Rate & Metal Markets 2. Supplier Data 3. NAECO Metal Prices 4. NAECO Calculations

The first worksheet of each excel file is used to determine the price of the precious and base metals. These prices are used throughout the rest of the worksheets. My database will just create a table to store these values and call them when the time comes. A single quote can contain one or all...

I figured it out. I was in the wrong place in my computer. here is all four sheets used for calculations in quotations:

I think the easiest way for me to explain it would be to upload the existing excel files used. the files are .xlsx and the site will not let me load them. any suggestions?