Search results for query: *

I'm sorry, I'm not understanding what you are saying. Here's a screenshot https://weathermatic.box.net/shared/static/g192nv26pn.jpg that might help better explain what I am trying to do. I want the order form to automatically pull only the parts that have a quantity entered. Maybe what...

I hope all of this will make sense. I have an Excel spreadsheet with 2 worksheets. One is a price list with approximately 150 or so line items. The other is the order form. Right now I have the order form set up with drop downs for a customer to pick the part number to order. However, they...

Thank you to lameid and PHV who helped me solve my problem that I posted yesterday. It helped me get further with what I am trying to do, but now I'm stuck again. Briefly, my database is used to create buying programs for our customers. Their discounts are based on the dollar commitment level...

Both of those suggestions work perfect!!! Thank you so much! I really appreciate it!! I need to learn more about SQL.

Wow! What a quick response. I'm not clear how I would make a query to replace the Dlookup function. My database is used to create buying programs for our customers. Their discounts are based on the dollar commitment level for the year. We have three different levels A, B, and C (levels are...

I have a dlookup in a report that works perfectly. I would like to use it in a query, however I can't seem to get it to work. I keep getting the same error: "The expression you entered as a query parameter produced this error: Microsoft Access can't find the name '2007 Smart Buy!2007...

I need some help with a report that I am trying to do in Access. Hopefully what I've written below helps explain what I am trying to do. I need help with Column F and a formula for K. There are about 10 different reports, all with the same formulas, for 8 different sales representatives...