Help with sql which counts records
Could someone help me to extend this sql to include:
1. a count of txtsole where the field is a YES/NO field and I want a count of
where the answer is YES
2. a count of txtmulti where the field is a YES/NO field and I want a count
of where the answer is YES
3. a count of txtsole where the field is a YES/NO field and I want a count of
where the answer is YES
4. a count of txtnbrparts where the field is a number field and I want a
count of where the answer greater than 1
I think I need to extend the WHERE statement?
SELECT tblhvdealspt1.txtablhybrid, Count(*) AS totals, tblhvdealspt...Item usage report #2
I am wondering if there is a report in GP that will tell me the same
information as in an item transaction inquiry, except give me the remaining
balance after the particualr transaction was done.
...6 items line-column chart on 2 axis
I would like a bar chart to show (in 2 bars) the forecast dollars and actual
percentage, where the forecast $$ use the right axis and the actual % use the
left axis. The final 4 indicies will be charted using a line chart.
When I create this chart my bars stack instead displaying beside each other
presumable because each bar uses a different axis. Is there anyway to show
the bars in separate columns?
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
"...Formula text count
I Have a list in a column that has a lot of tank numbers on a ship
listed as the following:
In another column, I have a list to identify whether the tank has been
opened noted with a date if it has and blank if it hasn't. I'm trying
to count the amount of V tanks that have been opened, J tanks that have
been opened and so on. I need an if, ifcount, or vlookup formula that
can do this. Any assistance would be greatly appreciated.
Let's suppose that the tank numbers are in A2:A101 and dates (or blanks) are
in B2:B101. In some...Requisition Manangement-Alpha Sort Requisition Lines Items on PO
When Requisition lines are transferred to a Purchase Order the sort order of
the PO line items are in a nonsensical order. Please consider bringing the
line items into Purchase Order based on alphabetical order.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http:...virtual serial ports
I am looking for information regarding virtual serial ports as I am
developing an MFC application that would need to be sharing GPS data with
another app and I have run out of serial ports (thanks to our touch screen)
and I will be unable to add more serial ports (usb used up too). So far I
have found people trying to sell me software but nothing about creating them
myself. I searched this newsgroup and could not find anything useful that
was software dev related. Any help would be appreciated.
On Fri, 9 Dec 2005 15:09:58 -0500, Erron Walker wrote:
> I am looking for information...Physical Invotory
I am planing to buy data collector for physical invotry count I like to If I
can use Symbol PPT2700 Barcode Data Collector . Is it compatible with RMS
Harjit SherGill /DBA
324 South Main st po box 370
Altaville CA 95221
Tel : 209-729-1410
Gill, any data collector that generates a csv file will be compatible with
RMS. Once the file has been uploaded to the host computer, go to RMS
Inventory and import the file. You will have to set the path to the file and
the file should be formatted with two fields, ILC and quantity. The da...Counting Within a Cell
How do I count the number of digits within a cell.
The answer should be four. I don't want to count the commas.
Something like this will work:
Tom G wrote:
> How do I count the number of digits within a cell.
> The answer should be four. I don't want to count the commas.
> Tom G
On 18 Dec 2006 01:05:15 -0800, "RichardSchollar"
I have a single column of information. Only SOME of the cells within this
column contain a string of alphabetic characters.
Some cells are empty. For example:
* What Excel command would allow me to count the # of cells that actually
contain alphabetic information within a certain range like A2:A100
try = counta(A2:A100)
> I have a single column of information. Only SOME of the cells within this
> column contain a string of alphabetic characters.
> Some cells are...302 worksheet (changing item costs)
We just changed a series of costs for a particular vendor. However when we
did a new PO the old costs came up. In checking the item properties we saw
that the cost was changed in the general tab area but were unchanged in the
supplier tab. Is this the way the program is supposed to work? Is there
anyway of getting the supplier tab cost field changed easily? Any input would
John G at the Tradewinds Shops
140 Wizard in SO
303 Worksheet in HQ
"John G" <JohnG@discussions.microsoft.com> wrote in message
news:8726E609-0983-4549-88BE-8...Physical Inventory Report #3
I am looking for a report which shows true item movement including any
physical inventory adjustments, transfers in/out, PO's and sales/returns
and Qty on Hand after transaction.
Does any one have a report like this?
Thank you for your post Jay.
We can accomplish a lot of customer report modification requests in Microsoft Dynamics Retail Support. We do have some limitations however, such as reporting on running totals, i.e. Quantities On hand as of a specific date/tim...Counting values in a range
Hi to all,
Range C5:C32 contains letters either "C" or "M"
Range D5:D32 contains letters either "M" or "F"
I want to count the number of combinations of the letters which are as
Starting cell D35 growing down to cell D38
I tried to write an array formula but always having an error.
Thanks in Advance
I'd simply use columns E, F, G, & H (which can be hidden if wanted) and
insert the following in each:-
F =IF(AND(C5="C",D5=&quo...how to count number of cells in a color ?
I have a list of data in column, they have conditioanal format to different
colors, e.g. blue, red, brown. I want to count the total number of blue.
How to do it ? The "CountIf" function does seem to help. Any suggestions ?
Regards Ron de Bruin
"Francisco" <Francisco@discussions.microsoft.com> wrote in message news:927304A5-05ED-425E-A5F5-AE981BA76DC7@microsoft.com...
>I have a list of data in column, they have conditioanal format to different
I am considering buying Visio 2003 standard to replace my ageing Visio 2000.
I will be wanting to use it to draw structural formulae for organic
chemistry. These would then be imported into Word 2003. Are any templates
avilable for this purpose? I am mainly interested in straight and cyclic
aliphatic compounds. I found this not so easy to do using Visio 2000.
Cheers and thanks
Visio at one time offered Chemistry shapes. I can't find them on the web.
A great source for shapes in general:
Chemistry Lab stuff:
how can we count how many weeks we have between a specific date in a cell
(A1 for example) and today?
With today in b1 try this:-
The cell this is in must be formatted as 'Number'
> how can we count how many weeks we have between a specific date in a cell
> (A1 for example) and today?
I didn't like the decimal weeks the previous formula gives so try this
=INT(ABS((B1-A1)/7))&" Weeks "&MOD(ABS(A1-B1),7)& " Days"
"...having the chart NOT count zero
I have a chart that takes in data from a column that has zeros all th
way down. I want the chart not to count the all the zeros unless ther
is a value higher than one, any suggestions
Sabrick's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3238
View this thread: http://www.excelforum.com/showthread.php?threadid=52881
...Missing Menu Items
I have a user that has the same security role in every company and her
Purchasing >>Cards menu is different in some of the companies.
She is supposed to see the 1099 Details, Buyers, & Customer/Vendor menu
items and for some reason she sees them in some of the companies but not in
Any ideas on what might be causing this?
Thanks in advance.
Can the user add the window to the shortcut bar and open it? This is a quick
and dirty test to see if access has been granted if the item doesn't appear
on the menu.
If you are using GP 10 I would copy the user's security...create a physical table?
Can I create a physical table or database from a Visio .vsd model? Can I
select one of the tables in the model and then have Visio create a physical
table for me?
if you have the visio enterprise architect edition that comes with
"mainspring" <email@example.com> wrote in message
> Can I create a physical table or database from a Visio .vsd model? Can I
> select one of the tables in the model and then have Visio create a
> table for me?
By referencing ADO...Tree control item is not selected.
Hi there, I found a suprising behaviour when showing a modal dialog
inside OnLButtonDown of a tree view. When I do that on a new tree item
it's not gonna be selected. The old item is still highlighted. Is that
the desired behaviour?
Here is what I do inside OnLButtonDown:
void CTreeCtrlView::OnLButtonDown(UINT nFlags, CPoint point)
AfxMessageBox( "Hallo" );
When I comment out AfxMessageBox() call. The new item will be selected.
> Hi there, I found a suprising behaviour when showing a ...Excel
Trying to write a formula that creates a count if a number in a cell in an
array (a column) falls within a certain range, and then adds them up: e.g.
I want to count if a number is greater (or equal) to 0.5 but less than 2,
and then add them up to return a value (3). I've tried IF, COUNTIF, AND, OR
but can't get it to work - Any ideas? Nigel.
Sumproduct should prove useful here ...
> .. count if a number is greater (or equal) to 0.5 but less than 2
> .. then add them up to return a value
=sumproduct((...counting in fields
Please note I am not use to using Access
I would like to be able to count items in fields. I have a table which I
produced by doing a query of 2 tables and making it a query table.
The fields are Client no, Date, nationality, gender, postcode, marital status,
and a few others.
I can do a cross tab query and count the items in each in field.
However what I am having trouble doing is bring this together in the one
report or query.
I am also open to suggestion as to better ways of obtaining my data.
Thanking you for any help that you are willing to supply.
please remember...COUNT and SUM
I would like SUM and COUNT all values >20, for example.
Thanks in advance.
(remove nothere from the email address if mailing direct)
"an" <firstname.lastname@example.org> wrote in message
> I have:
> I would like SUM and COUNT all values >20, for example.
> Thanks in advance.
"Bob Phillip...Counting with spaces
How do I count a total of things with spaces inbetween?
The answer I'm looking for is 4. Each date would represent a total of
one. The three entries on 5/5 would be counted as one.
Dim r As Range, x As Integer
Set r = Range("A1")
x = 0
If r.Value = "" Then Set r = r.End(xlDown)
If r.Offset(1, 0).Value = "" Then x = x + 1
Set r = r.End(xlDown)
Loop While r.Row < 65536
If Not r.Value = "" Th...Physical Inventory
I'm running Store Ops 2.0.0105. I generated a physical inventory by
filtering a category & inactive = No, but not all of the items in the
category were displayed on the count sheet. So the item that wasn't
displayed on the count sheet didn't get counted and now my inventory is off
again. Why didn't the item get added to the count sheet.
This is a multi-part message in MIME format.
Dunno, would have to l...Wrong Item In PO
Some times in a Purchase order when an item is clicked it doesn’t bring you
to the item that it is supposed to. it will bring you to a completely
different item. I have tried re-indexing the database but it doesn’t make any
difference. It is also not something that can be recreated at will. I usually
fix it by deleting the item from the PO and then adding it again. There have
been instances thought where the wrong inventory was committed to the wrong
item. Has anyone experienced this before or do you have any suggestions on
how to fix this.
What version of RMS SO are you on?