query to find when an event happened
I have 12 years of weather data in one table, and have queries to give
me total rainfalls between different dates etc, as well as max and min
What I would like now is a query to tell me what date in a selected
range the max or min temperature was.
I have tried the WHERE clause just see what it would return but I got a
Getting a related field from a GroupBy (total) queryat:
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/...mutimedia messages coming to inbox without attached files
Sending a picture from my phone to email. I use Outlook 2002 to read and send
emails. Message arrive but not the attached picture. My phone company email
site recieves the picture without any problem. Is there a setting in
OUtlook that is stopping the picture?
...Must buy new computer...Ideas?
Hello to all! Finally my over 10-1/2 year old Dell desktop's extreme
slowness has seriously gotten on my nerves and I'm now looking for a new
one. (Surprisingly, it's working pretty well otherwise...)
Maybe this isn't the right forum? But beside the usual things like RAM and
HD GBs, are there things I should be sure to have...or be careful NOT to
have on a desktop? After n ot looking into computers for over a decade I
feel like a Martian in the Earth. lol!
Also, is it possible to transfer to the new one ALL my stuff, including
programs, etc.? Do you thin...I used "save as" but now can't locate original file
I was using a file (November), changed the data, clicked "save as" (December.
Now, November is the same as December. Any possibility there's a temp file of
I believe you have not done as you describe.
If you had a previously saved November workbook open and made some changes
then File>Save As and named it December, November workbook will still be on
your computer in its previous state.
Unless you saved it as November with the changes.
From where did you open November workbook?
It will still be there.
Gord Dibben Excel MVP
On Thu, 1 Dec 2005 1...Default properties for new folders
How does one set the default properties applied when
creating new email folders? Currently, when I create a
new folder, it is created with the AutoPreview turned on
by default. I'd like to change that do that it is left
off by default. It's something of a pain to create a new
folder and then go in to customize it's properties.
You can do this by editing the Messages view; View-> Arrange By-> Current
View-> Define Views...
You might want to define a new view yourself and apply that view on first
use of that folder.
Robert Sparnaaij [MVP-Outlook]
www.howto-o...Need to Transfer Files Between Money and Quicken
I've got an interesting problem here. I need to transfer files between Money
2002 and Quicken Premium 2004. The first four attempts at having Quicken
read exported QIF files has been a disaster. Quicken is absolutely no help.
Their built-in help is referring me to webpages that don't exist. There is
supposed to be a tool to convert the file format, but the fine print says it
is for converting between previous versions of Quicken and Quicken 2004, but
it "may work" for converting Money files. A Quicken guru says I need to
export Money files to XML in order to bring the files i...New Email Messages
I just installed Outlook 2007 on my new PC and for some reason the new
messages I received can only be received when I press the SEND/RECEIVE
BUTTON. My Outlook at work receives these new mail messages as they are
received. So how can I configure the system to make that happen?
The Trail Hiker!!
There are two settings within the accounts
1) Send on starting
2) Auto send/receive every xx minutes - set this for 10 minutes
"hiker0531" <email@example.com> wrote in message
>I just installed Outlook 2007 on my n...Can't import .pst file to reloaded Outlook
Can anyone help?
Windows XP crashed and I was forced to reinstall the
whole thing. Before doing so, I managed to export my
personal folders to a .pst file that I put on a cdRom.
When I reinstalled Outlook and tried to import that .pst
file from the cdRom, I got an error message saying that
access was denied to the file. I then saved it to my
hard drive and tried again. This time I was able to
import the file but all it did was put an empty folder in
my list. The information that was supposed to be there
does not seem to be.
Is there a solution to retrieve my e-mails? Please h...How do I find the fat content for certain foods
I have just downloaded the excel template for weekly diet. How do I find the
fat content for certain foods?
(No private emails please)
"Kay" <Kay@discussions.microsoft.com> wrote in message
>I have just downloaded the excel template for weekly diet. How do I find
> fat content for certain foods?
> I have just downloaded the excel template for we...Prevent new comments on old posts in sharepoint blogs
How do I stop comments on certain posts in a SharePoint blog?
I have removed permissions to the specific post to the lowest possible
access and people can STILL post a comment. If I uncheck one more item in the
list of permissions, the users can no longer see the post.
...Unable to open "New" window to write email.
I am using Microsoft Outlook in Office 2003. It has been working great until
When I click "New" to write a new email I get an error window :
The messaging interface has returned an unknown error. If the problem
persist, Restart Outlook.
I have tried this several times, even restarted the computer to no avail.
Anyone have a solution????
...restoring system data from external HD .bkf files
My OS is Windows XP Media edition 2005. I recently reformatted my HD and now
I am trying to restore my Office Outlook files (.pst) plus system settings. I
have been only able to access personal files and folders. I really need the
..pst files. When I run the backup - restore wizard the check marks appear on
the two "C" drives, out of 14,471 MB on the external HD, only about 350 MB
are restored, the field "processed" reads "0" How can I restore the rest of
my system from the external HD?
On Thu, 27 May 2010 14:53:4...New Location/New setup
Currently I'm downsizing our office, and moving to a new location. I'm
running MS Server2003 as well as Exchange 2003. Once moved, I will no longer
require the server (since I am setting up a home office).
Are there currently any steps or procedures available to correctly shutdown
one office...and basically setup a home office with no exchange server.
Also I will be removing the current pc's from the Domain, and setting up a
few in a workgroup.
I would like to receive emails from the other employees for time being until
I completely cancel this email account. I already have a...A Short Video on Adding/Editing New Customers
If capturing customers at the POS is important to you, take a couple of
minutes and watch this video. This application also allows for edit of
Global customer information in HQ installations.
Contact us for detailed info and demo.
It would be nice if you could encode the videos with a more common codec,
and not in wmv format. This requires the GTM3 codec (GoToMeeting). Windows
Media Player 11 doesn't automatically download the codec, and I'm not going
through the trouble to download and in...Looking for Microsoft Office Binary File Format or File Signature data
I have an application which obtains numerous "unidentifiable" files
with no file extension, via FTP, and would like to run some sort of
binary filter on it to identify PPT, DOC, XLS file formats.
I did fine this: http://www.garykessler.net/library/file_sigs.html
But it seems a messy way of accomplishing this, and is incomplete. Any
clues as to finding the binary record format and/or file signatures of
Office documents (Office 2000 and greater).
...how to copy data in folder to ThumbDriv and use in other computer
I want to copy data in outlook folders of one computer(office unit) to be
used or pasted and read to another computer (at home),pls kindly advice how
to do it?
...Cannot Open 2002 Files in 2004
USA Money 2002.
Moved 2002 files to flash drive and tried to open them using Money 2004 and
I get this message "Type your password to access your files." The friedn I am
helping does not ever remember using a password. I guess the only option is
to use the Money 2002 program on the old hardrvie and see if that will allow
us to access the file.
The most typical case is where you are trying to switch regions.
Your second option requires that Money 2002 be installed. This sounds like
you are trying to upgrade a computer. BTW you can have multiple versions of
Mo...How do I activate the new mail button
When I start Outlook, the "New", "forward", "reply" and "reply to all"
buttons are not active which means I can not send mail. I have no problems
receiving mail. Also, on web pages with email links, when I click on them,
the Outlook application is not launched which is almost certainly related to
this. I think I'm missing something very simple here!
Are you in a mail enabled folder? Do you have an active email account
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert...Disruption of order of data series in 100% stacked charts
I have built a 100% stacked chart based on 4 yearly series.
My problem is the series are not displayed in the same order in every stack.
In one of the stacks, one data point jumps up from the bottom to the center,
a a a
b d b
c b c
d c d
2001 2002 2003
(d jumps up in year 2002)
I would like the series to be aligned and so to appear in the same order in
Tweaking the series order setting only serves to displace the problem.
Thanks for any suggestion.
Could you also post some typical data?
Jon Peltier, Microsoft ...Low disk space
I am running realy low on hard drive space on my laptop. When I run uninstall
I notice all the windows update files. My question is can you uninstall
update files or will it remove the updates from my laptop and mess everything
up? Any information on this would be greatly appreciated
> I am running realy low on hard drive space on my laptop. When I run
> uninstall I notice all the windows update files. My question is can
> you uninstall update files or will it remove the updates from my
> laptop and mess everything up? Any information on this would be
&...How can I know when a field is repeating during while data entry
My manager has this query. He is entering the stock details of his phamacy.
He has 6 columns. One is "name of the distributor",
the second is "bill number or invoice number",
the third is "amount to be paid",
the fourth is "cheque number"
the fifth is whether it has been "paid" or is "unpaid". The lst coumn I
have given conditional formatting, so that if it is paid, it will show the
fonts in green and if it is unpaid, it will show the fonts in red.
Now our query is that after say about 50 rows of enteries made, he would
like ...Style available all sheets new or old
I need a custom style that is available in all
spreadsheets, new or old. I can set style and save it in
book.xlt in xlstart, but that only works for new
workbooks, and doesn't work with old spreadsheets when I
call them up. I want to be able to select a group of
cells, or column or row and apply a setting for negative
numbers to have brackets. I am using Excel 2000.
I even tried saving the style in personal.xls, but that
doesn't work as it is hidden.
Do I have to use a macro? And if so what would it be?
Public Sub MergeStyles()
ActiveWorkbook....view a pub file
I d like to know how I could see a publisher file if I have not publisher ??
You can't. You will have to ask the sender to convert it to a .pdf file for
you. If they can't and this is a one time thing, you are welcome to forward
the file onto me and I'll do it for you. Send it to jl dot paules at gmail
MVP Microsoft [Publisher]
"Photo" <Photo@hotmail.fr> wrote in message
> I d like to know how I could see a publisher file if I have not publisher
&g...Sub Form Assigning New Values to Old Records
I am using a subform within a form to have users update certain fields in the
record where the rest remiain locked. On the Main form when the list box
(which is bound to a query) is used to select the record set to display in
the subform it sometimes takes an old record and assigns a new value to the
record. For example it changes the Period field from 9 to 10. Taking a
record created in period 9 and assigning a period ten to it which is the
selection I make in the list box. Addtionally, it looks like it is taking
the first record in the related table to assign this new value to. ...Problems with the sample data wizard
Hi, i want some help in some few questions about the installation of the
sample data wizard,
and add some domain users to the crm.
i had yesterday installed a crm (with the Adventure Works Cycle licence) on
a win 2003 environment, i have a sql server machine, an D.C. machine,
and finally a machine in wich i have installed the crm, with no problems
(the user that i use to install crm
was a domain administrator).
i assigned a licence to that user, and give he all crm default roles.
than i reboot the crm machine and log in with that user, run the crm and no
problems were encountred,