Recent content by awoitte

In my report, I've grouped by Template_Id (left column), and counted all proposals (second column) based on what template_id it is under. How can I Sort/Order by the count? I can sort by all the column names, but cannot figure out where to select the count of proposals found (in red) in the...

I'm going to try to elaborate one more time as simply as I can - Going off the original post & image -. Looking at the bottom portion of the image (results) Column C (2nd and 3rd row) - Two numbers POSITIVE 3, NEGATIVE 2. The 3 comes from the amount of parts released (or checked out)...

Lol?..........

I'm pulling data from my stockroom inventory transactions. For some reason, however, I'm receiving two quantities (positive/negative) quantity released and the quantity returned respectively. All I want to know is how many parts were actually taken out and kept out. I'm trying to avoid having a...

Not sure what's supposed to be happening here. Followed what I believed were your instructions: Selected Sigma and changed the Total = SUM for C. Group By was already defaulted in D as well as all other columns. Still seeing negative numbers and not getting totals.

I never said I wanted the negative numbers to return as positive. I want the difference between the positive and negative integer that have the same corresponding number to the right of it.

That sounds like something that would work, but how do I group two cells and sum the total into another column?

A query from one of our software databases shows quantity of items pulled from inventory known as a counter-release. However, the report is showing both the quantity that was released, as well as the quantity that was re-stocked into the inventory because it was no longer used, or the...

That did not work, screenshot attached.

I currently have access queries, that reports are being generated from and one of the columns that is a dollar figure is showing 4 decimal places. My original instinct was to edit the query, so when the report is ran its already changed, but I cannot figure out where to make this change at...