Recent content by shawnacker

Thanks Thanks for your help Jon. It makes perfect sense and of course works like a charm. You're the best!

Sql Thanks for the response...here is my SQL. Using this statement, all data is returned, BUT the Name and Date fields are blank for any rows where Table A does not have a value. Number1 does have a zero in the field and the calculation does work properly, I just can't see what the name is for...

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...

Pat, You are the greatest. I just adjusted the join type in my query and it worked perfectly. Thank you.

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...

I created a column which displays the count number. I have it counting the number of entries for the month. I also tried it with counting the reason codes and it (obviously) gave me the same number. Your newest suggestion produced the same result with no amount displayed for the month of May...

I tried using the NZ function and my query still returned nothing. Here is a more detailed explanation of my problem. I have a DatePart function which allows the user to enter the month and year that they are looking for in my table. My table has a date column, and a Reason code (which is...

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

Thank you. That worked perfectly!

The only thing that does is give the positive amounts. I want all amounts, both the positive and negative totals (whichever it may be).

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...