Multiple GROUP BY in a SELECT
I am trying to do something simple but failing. I am trying to get
aggregate data with different conditions in a SQL query.
That is, with a table date,fooA,fooB, I want to output rows containing
year, average fooA (where fooB=1) average fooA (where fooB=2) average
fooA (where fooB=3) group by year(date)
The tests I need on fooB are rather more complex but this is essentially
what I am after, but can't break it down into a single query. UNION
merges rows from different queries and I want to merge columns!
"Xmas" <firstname.lastname@example.org> wrote in message
n...Conditional Format Using AND
Please look at the following and help me with this conditional format.
Column A: This column is either set to "CURR" or "PREV"
I want Column B to be shaded "Red" if Column A is "PREV" and the the Current
YEAR is 2004, "Blue" if Column A is "PREV" and the Currrent YEAR is 2005.
I tried using conditional formatting but I didn't have something correct.
First condition: Formula is =$A1="PREV"
2nd Condition: Formula is =(YEAR(TODAY()))=2004 Set format to RED
3rd Condition: Formula is =(YEAR(TODAY()))=2005 Set format t...Multiple Queries to Multiple Reports
I have a database that tracks cadets that will commission into the military
and they are broken into their year groups.
My problem is that to generate a report for each year group I need a
seperate query for each year group so I have multiple reports and multiple
queries in my database.
I'm trying to figure out a way to eliminate all those quieres down to one
query and report so when I click the button to bring up the report a box will
open up asking me to type in the year of commission and then the report will
only show those cadets commissioning in that year.
Any hel...How to import multiple distributions with Integration Manager
I'm new to GP and IM so bear with me, please. I'm trying to import a CSV file
with detailed credit card expenses. I want to import this as one journal
entry (for the total amount against one account) and each line item from the
file should be a separate distribution of that journal to the associated
account from the file.
I just don't see a way to do this: if I use a General Journal I get one
journal for every line in the file and I can only specify one account. If I
use Fixed Allocation or Variable Allocation, there is no place to specify the
amount. Its sort of like a spl...Create Multiple Bugdets within a Fiscal Year
We have a client looking to create multiple budgets under one year, is this
possible with Microsoft Dynamics GP 9.0?
On Wed, 10 May 2006 12:31:02 -0700, Lisa
>We have a client looking to create multiple budgets under one year, is this
>possible with Microsoft Dynamics GP 9.0?
You can have an unlimited number of budgets for the same fiscal year.
"Lisa" <Lisa@discussions.microsoft.com> wrote in message
> We have a client lookin...ExceL Options: Add a chart for Box-plot type and Range function
I am a Process Engineer in a semiconductor manufacturing facility. I have 2
1. I use extensivelly a range calculation which is simply the maximum value
minus the minimum of a population. It would be very useful to have a function
(called range) to have it done at once instead of having to type max()-min().
2. For populations comparisons we use box plots. It would be nice to have a
chart type for box plots.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this sugge...List box help
How do I select an option in a list box and have it send me to another list
box. Such as. in list box (1) I have numbers 1 - 10. If I select, say,
number 5 I'll need it to go to the other list box where I will again have
choices to send me to another list box. Actually just a way to narrow down
to the final choice.
Have a look here:
"Ken" <email@example.com> wrote in message
> How do I select an option in a list box and have it send me to another
> l...Multiple namespaces
Is it possible to write the following with the use of XML? How?
Can someone help me out.
Thanks in Advance
> Is it possible to write the following with the use of XML? How?
That is a start tag of an element with local name RDF, prefix rdf bound
to the namespace URI http://www.w3.org/1999/...Multiple email aliases but emails sent to always show same display
Have an AD account that has multiple SMTP email addresses. However, any
emails sent to one of them always show being sent to the users display name
so theres no easy way to tell exactly what email address it was sent to.
Does anyone know what we can do?
Only thing I can thing of is creating separate AD accounts for this emails
but that is a way too long winded.
Monkey <Monkey@discussions.microsoft.com> typed:
> Have an AD account that has multiple SMTP email addresses. However,
> any emails sent to one of the...slow grid on form in Access 2007/Vista
I inheriteid an app with a data grid on a form. The performance was
acceptable in Access 2003/XP, but is VERY slow in Access 2007/Vista. A one
second operation to populate the grid in Access 2003 takes about 15 seconds
in Access 2007.
Are there any known issues that I should be aware of?
i think Allen Browne explained it best:
also some fixes not all specific to the vista issue:
> I inheriteid an app with a data grid on a form....Multiple Update values in one query
Can I use multiple values in one update query to update one field based on a
value in the field. I have a field that can have 5 possible codes (0,1,2,3,8)
and I would like to run one update query (I know I can write 5 different, but
hope can do in one) to change these values to their actual device
equivalants, for easier to read. If value = 0 then Pollcat II, value 1
Pollcat III, value 2 Netlink, value 3 CC3, value 8 FTP. Is there a way to
do a Case type statement in an update query?
Thanks in advance
On Jul 6, 1:26 pm, Kenny A. <Ken...@discussions.microsoft.com> w...Text Box
Is it possible to insert a text heading, within the border
of a text box?
Ie. So that the border wraps around the text box as per
usual, but in say the top left corner, the border breaks &
the heading text is inserted?
> Is it possible to insert a text heading, within the border
> of a text box?
> Ie. So that the border wraps around the text box as per
> usual, but in say the top left corner, the border breaks &
> the heading text is inserted?
I'm not exactly sure what you are trying to accomplish
but it soun...Setting up multiple accounts
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: pop
Hi guys, <br><br>Just switched over to the mac world and am now setting up my email. <br><br>I have 2 separate email address all hosted on the same mail server - mail.tpg.com.au <br><br>I added my default email address which works fine in Entourage but I continue to get the following error message with my second email account: <br><br>Mail could not be received at this time. <br><br>The server for "Cheekyage's" r...Delete contact from multiple distribution lists
I manage multiple distribution lists, and often have to remove a
contact from myriad distro lists. Is there any way to pull this off
without having to delete the contact from each list individually? I'm
using Exchange 2003.
Not that I know of - by the way, Exchange questions can be asked in =
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, Stockmoose16 asked:
| I manage...Multiple (two) back-end MDB's.
How does one go about structuring the concatenation
of back-end DB's? That is, for example, a single
application that has one back-end that is common at
each of multiple locations and a ("site") second back-end
that is peculiar to each of those locations.
The common mdb would desirably be read only while
the "site" mdb would be updateable.
Given that there's a straight forward answer to this
question, my next question would be how to create
the common mdb based on a query of a "master"
DB. (The "master" location being the point of
...All my forms Modified date are the same after compact and repair
I have an access front end that compacts and repairs after each time it
closes. What it is doing is setting the modified date to all of the forms to
the system time and date when the front end is closed. This is the link from
Microsoft but it doesn't have any resolution. Does anyone know how to correct
"Jerry8989" <Jerry8989@discussions.microsoft.com> wrote in message
>I have an access front end that compacts and repairs after each time it
> closes. What it ...LED light box--Only 11 mm LED slim light box in China! #2
Only 11 mm LED slim light box in China!And the price it very
cheap,only sell for 289-329 USD /Metre .
Order today!Buy more,save more!
...Forward generic email to multiple accounts?
We have several "generic" email accounts; "firstname.lastname@example.org", "email@example.com",
We need to make sure several different individuals receive any email sent to
The forwarding feature in the user account properties only permits one
address as a forwarded recipient.
Permitting users to "also check these mailboxes" in Outlook seems to direct
the email to whomever checks the generic mailbox first.
How do we get mail the generic mail to several people simutaneously??
create a mailing list and forward to that list
"S...How do I add .htm to every link in a worksheet? Multiple hyperlinks+targets
I have about 500 hyperlinks in my worksheets. An example of 1 of th
links = "..dvd/1994/940602"
As you can see, i forgot to use the file extension i wanted to link t
(*.htm) Is there a way to edit 500 links by automatically adding .ht
to each one with out me going the manual route. i
Also how do i change the "_parent" to "main" so all the links open i
the main window, and not just a new page.
When i have the page saved as html, i can go in find and replace i
wordpad which easily changes the links (searched on "target =...Excel Spreadsheet Shows Nothing!
I tried to open this excel file, it is not showing anything! No spreadsheet
shown at all. When I try to re-open, dialogue box says file already open but
even the task manager is not showing anything at all! Oh no....this is a very
important file....what's going on? Even when I go to the excel "Window" menu
, this file is not there!
And when I email the file to a friend, the file cannot be opened either.
However, there is this "Viewer" in Lotus Notes, when you open through the
"Viewer", everything is there!
"Dolphi...Multiple database files created
I have an Access 2007 database that resides on our company's server. The
database tracks incoming and outgoing shipments and is used by several
employees throughout the day. I've noticed that in the folder where the
database resides several additional database files are created throughout the
day with names like database.mdb, database1.mdb, database2.mdb, etc. Can
anyone tell me why this is happening?
The database was created with Access 2007 using the 2003 mdb file format, as
most of the end users have Office 2003 applications.
1. Turn off...**Multiple offices multiple deposits**
We have a number of offices that prepare their own deposits and take this
cash to the bank. We are in the process of rolling GP out to these offices
through Terminal Server and wonder how other multi office companies deal
When having multiple people creating multiple receipts and deposits within
GP, how do you handle it so that each receipt/check is easily recognizable
by the person who is inputting the deposit?
Thanks in advance for your advise!
You can have each person doing Cash Receipts or Bank Transactions code
the Receipt number/Transaction numb...how to add numbers from different areas in chart and importing forms from word
can someone tell me how to add numbers from different places in a chart
i.e. lets say 10 numbers are in different places and I need the tota
of these ten- is there a way of obtaining this by selecting the
without putting in all the numbers separately somewhere to arrive at
Can a table be imported from word into excel. i.e a multi row tabl
with 2 o r 3columns and it visually will look like its in normal vie
word but in excel. can someone tell me
carole's Profile: http://www.excelforum.com/member.php?...Word Art won't show up in Print Preview
When using the Print Preview option, neither Word Art or clip art will show up.
UNcheck "Draft Quality" in Page Setup.
> When using the Print Preview option, neither Word Art or clip art will show up.
...Problem with Text box and Background
I am using the background as a temple for a form
I add test boxes where I want to have text typed in
The problem is when I print the page the text I have typed in isn't where it
is supposed to be
It is below the line of the background form
How do I solve this problem?
Best asked in the publisher.webdesign group
Mary Sauer MSFT MVP
"News" <firstname.lastname@example.org> wrote in message
>I am using the background as a t...