Search results

I have what seems to be a fairly simple question. There are two tables in my database. A and B. Each table has the same criteria: Name, Number, and Date. I have created a formula in my query which will add the Number fields together when they both have the same name. My problem is that when...

I have searched for days and not been able to find an answer to a supposedly easy question. I have a continuous form "Entry_Form" based off a table called "Today". I want to add additional criteria to the table using the form and have created a combo box that is based on a separate table...

I have looked through past messages and found two possible solutions to my question, but I am not sure which is the best to apply to my problem. Should I use Nz or IIF??? I have a two tables. One table includes many account names and one which includes some of the same account names (never...

Hi, I have created a Form which has cascading list boxes and separate text box which help select criteria for a query which I have created and runs correctly. I would like this query to "print" on the same form just below the selected information. I have tried a subform but I can only seem...

I am trying to create a query which will be used to create a pareto chart. I have my first criteria which is my number of differences and I have calculated a percentage based upon each type of difference. I would like to create an ongoing sum of the differences until it finally reaches 100%...

I have created a Chart in Forms that is linked to a query. I created it as a Form so that it will run the query each time. My problem is that I want a title for the chart to include a part of the parameter. I have tried to create a text box but that does not work. Is there another way to do...

Hi! I have a query which counts the number of certain occurences in a particular month. In one month there were no occurences. Is there a way to have my query results show a 0 instead of nothing at all? Thanks in advance, Shawn

I have a table with a a column that contains both positive and negative values. I also have a query which totals these values. I would like for my query to return the absolute value total instead of an aggregate total. Do I need to create a separate table just to do this or can I input some...