Query Criteria 04-15-10
Some of the fields I have in a table which is imported from a csv file are:
Salesperson (has up to 20 names in it)
Status (has Won,Lost,Submitted,Prospect,Did Not Proceed,Estimation)
Status Date (has date)
Value ($ value)
What I am getting stuck on is a query to get the total value per Salesman
for each status and also the count of each status, I would like it to show
in datasheet form something like below.
Salesman $won No. Won $lost No.Lost
A $100000 5 $150000 3
B ...Excel query #5
I'm using Microsoft Query to get data from my Access tables. After the 64th
query, I get the message "[Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed", which means I can't add another query. I need
several more queries. Each query has 53 fields. Can I increase the number of
queries the driver can open some way? If not can, pivot tables or OLAP cubes
open more queries. I have played with them some. Can they open that many
fields? Are pivot tables or OLAP cubes the best way to handle the data?
I'm not looking for a 'how to' ans...Another issue with RPC over HTTP and credential prompts...
I have this set up at about 25 total locations, 20 of which are working
flawlessly. The other 5... well please let me know if you can help!
I have each location logging into a domain accross a VPN. I have implemented
RPC over HTTP to minimize the load on the VPN equipment. The issue is that
at 5 of these sites, they keep asking for the logon credentials when you go
I have installed the certificate from the server, I have made sure that the
terminals are using credentials that have not expired. If I allow the
terminals to connect using the normal RPC method that...Queries to Views?
I posted this question in a SQL Svr newsgroup and was basically slapped down
for doing so. I was told this is an "Access" issue and I should try an
"Access" group (man, those guys can be sensitive!). So, here we go...
I've tried a few different approaches but, each time I try to convert an
access query to a view in SQL Svr 2000, the result is a table not a view.
Does anyone know how to take the dozens of queries I've created and move them
into SQL server as views without copying and pasting the SQL statements into
query analyzer one at a time?
I've ...Templates and Queries
I have an Excel Template that contains a query pulling from and Access
Database. I have tried to modify this query, however, it doesn't seem to
accept my changes. I can create a new query within a new template and then
it works fine. Rather than doing this for everyone, I would like to just
modify the query and save that within the template. I've tried saving the
query and then resaving the template also. What am I doing wrong. This is
...On line price updates corrupting number of shares
Recently there has been a signficant change in the way Money handles
updating investments with the latest prices.
Before Sepetember (and going back to at least 1997 when on-line updating
became available and I started using on-line updating) when you hit
"Internet Updates" only the LATEST price for a stock was downloaded.
Now suddenly a complete history of weekly prices is downloaded. This in
itself is not necessarily bad, but for a signficiant number of stocks in my
portfolio PHANTOM SHARE SPLITS have been introduced. ie share split when in
fact there were none.
eg Austra...Excel Won't Recognize Numbers
I can't get Excel to recognize numbers when copying text from a specific
site for some reason. When I copy and paste numbers and search terms after
doing a query from this site...
it seems that in excel, they display with a space before each number and
each term. I'm not an advanced user and I just can't seem to get rid of the
space so that I can sort by number or by term alphbetically (without manually
deleting each unnecessary space). I have tried using the 'trim' function,
paste special->value...Network connection for query
G'day there One and All,
I'm currently trying to adapt a few of the Dept's workbooks to suit our
district. There is a single master book, to produce reports, that
is available to all on a read only basis and read write to the
relevent manager. There are also a number of data entry books that are
identical to each other and that provide the data from each division.
The master book uses a query to obtain data from the division's books
and thereby build the reports. The data books are read write for
everyone with only a single sheet from each providing data for the
que...Query to find when a total is hit
We are trying to get some statistics on our Inventory people to see if they
are issuing material to work orders on time. My work order table has a
field that shows the last transaction date of the order, but if Inventory
issue all the material then has to issue more because of scrap later they
get dinged as being late.
We have a Transaction History table that shows every issue however I don't
know a good way to find out when the total number of needed parts was
reached. For Example I am creating a shop order that needs 3 parts, 50 of
ShopOrder PartNeeded D...import from MS Access
When importing Access file to Outlook 2003 contacts using wizard, phone number fields without area code in source have default area code inserted in the outlook contact, i.e. 555-5555 in Access becomes 222-555-5555. This is happens for all numbers in all phone fields.
...LDAP Query needed
I need an ldap query to find all users with an exchange mailbox where the
users alias does not equal the nickname of the smtp email address(s). Thanks!
"MrRAlan" <MrRAlan@discussions.microsoft.com> wrote:
>I need an ldap query to find all users with an exchange mailbox where the
>users alias does not equal the nickname of the smtp email address(s). Thanks!
I don't believe LDAP supports what you want to do. You'll have to
write a small program (vbs or perl) that creates a mail address and
then queries the AD for a match.
MCSE+I, Exchange ...Queries?
Is it possible to make an "update query" to roll back year to date overtime
hours? I have an tblhours that totals all overtime hours worked and refused
in which I have ran queries to sum all of those. Once a year we have to
rollback the year to date overtime hours which means we take the lowest
employee, he goes to "0" and we subtract the lowest employees hours from the
highest employees hours. I was trying to do this in an update query, but
everything I try subtracts, for example, 10 hours from every line of
overtime in the tblhours table. I know you are no...Excel VBA SQL Query Filename
I recorded a macro to pull in an external dbf file using a SQL query
in VBA (Excel 2003 on an XP machine).
Everything works great until I point it at the original file (was
pointing at a renamed copy) that I want to pull in. The files I need
to pull in will have the format <output filename>~<model 1>~<model
The SQL query doesn't like the strange characters (~'s) in the
filename and if I try a wildcard within the filename (i.e. <output
filename>*<sub model> or <output filename>%<sub model>) it doesn't
l...Help with query... 10-19-07
I need to create a querry that needs to have values of two
different columns to be looked up in another table. Ex.
I need a querry that will display the Note, Description from the
Status table (where PaperStatusID = StatusID), and Description from
the Status table (where DigialStatusID = StatusID).
I need this in a single query, but I'm not good at queries yet and
can't figure out how to do this.
Here is sample data to clarif...How do I get CD-RW to be revisable?
I don't understand your question. Does this have anything to do
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Angie" <Angie@discussions.microsoft.com> wrote in message
...eConnect registration failure
I had been successfully using eConnect for Great Plains 8.0. However, upon
reinstalling business objects (we were writing support doco) the registration
step failed and consequently eConnect has ceased working. The error during
install simply states "Warning! Registration failed."
We are using the same registration key as before. Do they expire?
Do eConnect keys become invalid if other GP features (national accounts) are
The user is in the DYNGRP sql role. So what else would cause it to fail?
What diagnostics is possible?
...Search Function with queries
new user to access 2000 and i am trying to create a search
query that will allow me to enter in a value and return that value. The part
i am having trouble with is i need to do this for many fields and if i use
the method i came up with, when i leave a entry empty using the "AND"
function i get nothing and when i use the "OR" function i get all the values
for both. maybe you guys can help me get in the right direction.
this is the command i am using in SQL:
SELECT [Chain Machine prod Machine list].Description, [Chain Machine prod
Machine list]...Querying master worksheet
I have a master worksheet that runs from an Access query. After it is
populated I want the other sheets to be populated dynamically. So like
ColumnA ColumnB ColumnC
Agent Supervisor Calls
b. smith 1199 3
s. jones 1199 6
a. sharma 2244 4
a. chong 2244 5
Header: Supervisor Number: 2244
So basically each worksheet brings back...INSERT INTO Query Converted to VBA
I have a append query that works great if I just run the query via Access. I
need to convert that query into VBA code. Here is the SQL View of the query
I'm trying to convert:
INSERT INTO TblInitiator IN 'I:\Archive\TestFinal\080107\TS3000v101_be.mdb'
What the query does is append the table called tblInitiator located in a
network location from values in a table called tblAddInitiator. There is only
one field in each of the tables both called fldInitiator
I tried this VBA statement (all on 1 line)
AppendDB = "IN...How do I run a SQL query against a MS SQL Server database from exc
How do I run a SQL query against a MS SQL Server database from within Excel
2002? I know it can be done somehow using the SQL.Request addin function.
However my attempts using this function have continually failed. Can some
one please provide a working example to the pubs or Northwind dbs that I can
work with and use to help debug my attempt? Thank you!
Have just recently upgraded customer from v7.5 to V9.
They have specialised inventory item numbers that include dimensions but
when they print their SOP sales invoices - they only require the first 6
digits printed. We achieved this a while ago by putting a format on the
Since the upgrade one user has experienced a printing problem as the full
item number appears - we have now establised that it is only if the user uses
a smartlist to select the invoice and drills back to the invoice to print. If
they use the inquiry screen to select the invoice - all is ok.
Anyone any i...Multiple database query
Hi gang -
How can I make a query work with two databases on the same server- I tried
this but its not working - [both databases are exactly the same]
SELECT KEP.dbo.PM30200.VCHRNMBR AS PaymentNumber, PM30200.VENDORID,
PM30200.DOCDATE AS CheckDate, PM30200.DOCNUMBR AS CheckNumber,
CONVERT(varchar, CONVERT(MONEY, PM30200.DOCAMNT), 1)
AS CHECKAMOUNT, PM00200.VENDNAME, PM30200.CHEKBKID
FROM PM30200 INNER JOIN
PM00200 ON PM30200.VENDORID = PM00200.VENDORID
WHERE (PM30200.DOCTYPE = 6) AND (PM30200.DOCAMNT > 25000) AND
(PM30200.DOCD...The column prefix 'c' does not match with a tablename or alias used in the query
I got his error message on this scritp which I do not understand:
select Top 1500
p.master_customer_id as parent, c.master_customer_id, c.label_name,
usr_othuntsmngmnt+c.usr_lchountsmngmnt + c.usr_genbedmngmnt + c.
usr_rescaremngmnt + c.usr_shelteredmngmnt + c.usr_supportedmngmnt) as
sum(c.usr_pbuntsowned + c.usr_rhuntsowned + c.usr_othuntsowned + c.
usr_lchountsowned + c.usr_genbedowned + c.usr_supportedowned + c.
usr_rescareowned + c.usr_bsuntsowned + c.usr_shelteredowned) as
TotalUnitsOwned...counting the number of times shown
I am trying to figure out a way to put a numerical value next to the id that
is shown, suggestions?
ID This is what I am hoping to get to show up in the next column
With ID in column A, insert this formula in B2 and copy it down as required:
"klh84" <email@example.com> skrev i meddelelsen
> I am trying to figure out a way to put a numerical value next to the id
> th...backing up to a CD-RW #2
When i attempt to backup to a CD-RW, I am instructed that I do not have
administartor's privlidges to do so. I have Windows XP, and I am the
administrator and only active account. I have double-checked and I am listed
as the computer's administrator. Is this a "Money" administrator, or
m> When i attempt to backup to a CD-RW, I am instructed that I do
m> not have administartor's privlidges to do so. I have Windows
m> XP, and I am the administrator and only active account. I
m> have double-checked and I am listed as the compute...