Search results

I have a query that returns all customer concerns that have cost the company money by either shipping free parts or paying an invoice. The query returns all data and some fields are blank. For example, if I ship parts only the invoice data is blank as vice versa. I want the null value to show...

I have a customer complaint form that has numerous customer data fields. The first field is a frop down box that links back to the customer table. When the operator selects a customer it auto populates the customer data. From time to time we will run across a new customer that is not in the...

I built a query that looks up all customer complaints from a certain time frame. It pulls from an invoice table and a order table. In the query I want it to calculate a total $ spent. Here is what I have so far but it does not work. The following fields are from the order table. Standard...

I currently have a database that records customer complaints. In some cases the data from one complaint may be the same as the new one. What would like to do is have a button on the bottom of the form that will copy the current complaint (All fields) to the next / new record. How can I do this?

I need help on two issues. 1. I have a query that calculates cost per incident but many of the fields have a null value. How can I make the null values = $0. 00? 2. I want to create a button on the bottom of my form that will copy the current record to the next new record? Thanks for your...

I have a few issues I need help with. I have a query that calculates $ spent per incident. Some of my fields have a null value and in the query I want a null value to show $0.00. I want to create a button on my form that will allow me to copy the current record to a new record. Thanks in...