Search results

Good afternoon! I have an issue that is probably very easy to solve but can't seem to get it right. I am working in Access 07 and in the database I have attached, I have three separate tables that list market managers (tbl_MM), Chemicals (tbl_Chemicals), and Area (tbl_Area). One market manager...

Hi! I have a memo field that needs to be entered onto a form based on selection made in previous text boxes. When the memo field was a text field, it worked fine with [ProdNo].[Column](3) but now that I need the additional length that the memo field provides it brings in the memo field text but...

Is there a way to get this to work or another way for me to calculate the total?

Thank you but how did you add in a non-calculated Size field to have it bring in the value automatically?

My line total is a calculated field and the sum feature won't work in calculated fields from my understanding.

I had a working form but then my client asked for the form to be changed and with those changes my subform is not summing the totals in the footer properly. It is giving me a #Error message. My line total is working fine with the formula =([Size]*[Price])*[Qty] but when I enter...

I have a query that is based on two tables; main quote table and the product table. In the product table I have a yes/no box for if that product was purchased. What I want the query to do is run and display all the quotes that do not have a the check box checked; however, I want the whole quote...

Thank you for your help. It is very much appreciated. I have attached an Access 07 test database with false data for you to review. What I need is on the Customer form to be able to view the quotes attached to that customer and if the quote produced an order, enter that order and mark purchased...

Thank you for the clarification. I have bound the text box by adding a field to the table; however, I am still not able to enter different numbers for one ID which is what is needed. Some quotes have multiple orders attached and I need to attach the order numbers with the quote numbers. Is this...

Thank you. I have unbound the box; however, it is still not allowing different entries. Any suggestions?

I have a form based on a query that pulls quote numbers and lists what was on the quote as well as the prices. I want to add the order numbers to the quotes if the products were ordered; however, sometimes the quote is in two orders and I need to distinguish the quote between the two orders...

I have a form and a report that list a company name from the database but needs to have additional fields completed by that customer. We want to be able to have the form or report fillable electronically so that they can complete it and return it electronically. Is there any way that this can be...

Thank you for the help. For the query, would I create a new field called total to put the if statement? I want to show the list price on the form but if there is a discounted price that needs to show as well and the total needs to be the qty times the price or discounted price if there is one...

Good day! I have a form that currently calculates a total based on the qty times the price; however, we want to add a field that lists a discounted price if applicable. What I need is the if/then statement I would need to use to have the total field look at the discount price and times that with...

THANK YOU! I was able to complete this project with your help.

Thank you. How did you get the price to pull into the table?

Here is a copy in Access 03.

That site was helpful so thank you; however, I am getting an error still on both sections. Can you help me understand why? I have attached an updated test database in Access 07 for you to review. Thank you!

Hi! I have a form with a subform that list out products and prices. One of the subform fields caluculates the total cost by multiplying qty*price. I would like to have a grand total of that on my main form would be prefered but everything I try is not working. Does anyone have any suggestions...

Thank you so much! Your first suggestion worked like a charm.