Search results

Hi there, Tried both ways, and still not working. If there is a value in the top (first) row of the query, the calculation works fine - I have [HeadWholesale] with data entered, and I can add, subtract, multiply, etc. by this value. However, when I try to add [Headwholesale] +...

The LEFT Join worked. I can now see all of my results. Next problem - I can't get any calculations to work in the query. I put [fieldname] + [fieldname2] in the expression, and it askes me for a parameter value for [fieldname]. I have the fields in the query, all visible, and pulling the...

Got it. Worked perfectly! Thanks for the Help!!

Hello, I have been working on this for awhile, and am definitely missing something. I have a query that is pulling data from multiple tables. When on of the fields are blank, it does not show the result in the query. I have tried Is Null in the Criteria and Is Not Null in the OR section...

Hi All, I have looked around for the answer, and am still confused, so help please. I am using Access 2010, and understand how to email a report or save it as a pdf. My problem is when I email the report, and select to send it as a pdf, the name of the file is the same as my report (by...

Hi and Thanks for the response! My OrderDetails table has some of its product specifics populated in a form from info from unrelated tables. After a bit of research, can I use the DLOOKUP function to get info from these unrelated tables into a query so that I can do some calculations? If so...

Hi All, My DB has an Order Details table that uses dynamic combo boxes to fill in criteria from my form. The Oder Entry form uses a combo box to select the type of product, this generates specific choices for values in the next product combo box (from a product table), and so on. The result...

Got it figured out. Thanks for the help!

I think I understand the concept, but am not sure how and where to put this expression. I have my query built with the CustomerID, Address1, Address2, City, State, Zip, OrderID, Shipping Address1, Shipping Address2, ShippingCity, Shipping State, and ShippingZIP fields. How would my Iif...

OK, makes sense. Hadn't thought of it that way. Can you show me some detail (steps, code, etc.) of how to do #3?

Hi there, I have a DB with the Customer address in the Contacts Table, and a product shipping address in the Order Table. I have added the shipping address fields to my form, and would like to put a check box that automatically populates the shipping address fields with the Customer address...

That worked. Thanks so Much!!

Got it. I'll try that. Thanks!!

Sorry, but I don't know exactly where to insert the code for the third combo box. Can anyone help?

Thanks for that! Can you give me an idea about how that code would look based on my example? Thanks!

Hello, I'm new to the forum, and an intermediate Access user. I really would appreciate any help! I have created a form with multiple combo boxes. The user selects a value from the first combo box. The result of this choice changes the selection of the second combo box. Here is my...