Search results

Hello, I am working with an orders database and want to build a mailing label query that will not print duplicate labels. In the query I have the customer address book and the orders table. I know how to create the query to filter the year I want but how do I add the customer information as to...

I have an Orders form with a subform with the products, price ext price tax etc. On the bottom of the subform it will not total the subform information example =sum([ExtPrice]) will not return a value it's blank. take away the =sum and just put in [ExtPrice] and the value shows up but not...

Was wondering if there is a way to incorporate the DatePart function in the below statement to filter out sales tax by quarter? I have two drop down boxes that filter the year and the state but the below only totals the tax for the year and state. I am trying to add 4 text boxes to show the...

I live in New Jersey and have been using Access for different projects for a few years. I pretty much just use the basic functions and would like to dive into the more complex areas of the program. I am looking forward to diving into this forum and seeking information I can use in future...