Search results

I have a pivot table that pulls from a data worksheet. Everything looks correct except one columns sum is 1 off. The sum should be 30 but it states 29. Based on the the data is is 30. Also when I look at each subentry it adds up to 30. However the sum shows 29. This is the sum of a column btw...

I am getting an unsual problem. I have two groups in a column...one is rails and the others are trucks. The unsual thing is that I get the right number of rails when they are summed at the bottom of the group. However I do not get the correct number of trucks. When I calcuate the total for both...

Man who are you telling!? Lol...I had to find out the hard way about the parameters issue you mentioned when I created a report that linked to the crosstab query. I had to also put in explicit information into the columns headings section of properties. Crosstab queries are great and horrible...

I figured out why the error was occuring. In my calculation one of the weights was divided by zero giving me an #Error in the query. Apparently a crosstab query won't work with any errors, so it gave me the overflow (most likely due to the divide by zero). Either way it works now.

I tried using both First and Last however I still get an overflow error. When I tried with less numbers it worked though. What I dont understand is that the amount of records I am working on is pretty small...so why the overflow error?

I tried using the crosstab query but the issue is when I select the value portion of the query, I dont want to do any aggregate operations on it...I just want the value itself. Even when I go ahead and just say "sum" I get an error that says "overflow"

I have a query that has three columns: months, weights and locations. In a report I want the format to be where the months are the column header across the top, the locations are the row headers on the side and the data filled in is the weight. However when I do this I get constant repeats of...

Thanks to you both...got it!

When I wrote that line before the openreport nothing happened...I just got the report opened with the #Error again. However I went in and stepped through the code. When I reach the last strWhere this is what I get: strWhere = "[Plant Number] IN (13,55) And [Material Number] IN...

No...Ive tested each list box out seperately and they are indeed correct. It is when combining both strWhere statements is where I have trouble.

streWhereMaterial and strWherePlant are formatted the same: strWherePlant = "[Plant Number] IN (" & Left$(strWherePlant, lngLen) & ")" strWhereMaterial = "[Material Number] IN (" & Left$(strWhereMaterial, lngLen) & ")" These show what numbers were selected in those respective list boxes, for...

strWhere = strWhereMaterial & " And " & strWherePlant When we arrive at the whereCondition, strWhere should hold the Materials selected in it's list box and the Plants selected in its list box. These are multi select list box so they can have more than one selection. If none are selected then...

I'm sorry, I'm not too sure what you are asking...what does which string contain at what point?

I have two strWhere statements in some VB code, each representing a list box. Individually they work but when I try to combine them I get either #Error when I make a selection from both list boxes or a syntax error 3075 when only one list box is selected. Currently I tried combining the two...

Ok...I've got the copy and paste part but I still get errors. After debugging I realize that my Where statement isn't being read right though the right variables are in it. This is one of the last statements I run. DoCmd.OpenReport strDoc, acViewPreview, WhereCondition:=strWhere...

Ok, I've been able to successfully implement Allen Browne's Multi Select List Box in a form I have. However I have two more list box that I need on this same form with the same features as the first. How do I edit his code to add in additional list boxes without totally messing it up. Here is...

I have a table with Employees and Employee Roles. Employees can have any number of roles. There are 27 roles to be exact. Now the thing is some employees may have only one role all the way on the 27th role column. What I want to do is update the table to where for each employee, all of their...

I was wondering if it was possible to freeze panes in an access report, similar to how you can in Excel? This would be for when you have a long report with many columns and want to scroll through them, yet have a fewe fixed columns at the beginning. I dont think this is doable but I thought I...

That worked! I didnt have to put Sum in front of it since it already did the running sum. Thanks!

I have an equation in my "Details" section that figures out the amount of cars that come in each month. Now in the footer section I want a sum of all the cars. So I tried copying the expression and wrapping Sum around it ( =Sum([equation])). However doing this causes Access to crash when I try...