Calculating the number of entries between 2 times
I am working on a Dispatch records workbook. I am trying to get counts of
entries between 2 time frames. Example, How many entries between 8:00AM and
9:00AM, 9:00AM and 10:00 AM etc. I can get counts using less than, more than,
and equal, but not have had much luck with getting counts between 2 values. I
would like to also get response times(the time the call is received to when
it is dispatched) between 2 times. Any suggestions?
Ok, the first thing you have to do is to better define the time intervals.
8:00 AM to 9:00 AM
9:00 AM to 10:00 AM
So, if the time is 9:00 AM whic...An Address Mess! #2
Thanks a ton. I think what you suggest is something I'll be able to us
in many other projects.
Have a great weekend! ;)
Carolina78703's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1562
View this thread: http://www.excelforum.com/showthread.php?threadid=27167
...On behalf of #2
I have done something wrong. When any user tries to send internet mail it
says they are sending on behalf of themselves.
Outlook used to route internet mail directly to the external pop3 server,
now it's trying to route it through exchange server.
...Calling Dex Procedures from SQL
Is there any way to call dex procs from SQL or VB code?
There is an undocumented and unsupported method of calling Dex code from
VBA. However, I know of no method of calling Dexterity from SQL.
Please email me if you want an example, just remove the online. from the
David Musgrave [MSFT]
Senior Development Consultant
MBS Services - Asia Pacific
Microsoft Business Solutions
Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This p...is SQL 2000 architecture different SQL Server 2005 / 2008 architecture?
Hi I have a book "inside SQL Server 2000" by Kalen Delaney, which I
have been told is a good book. I am going backwards... reading about
the sql server architecture in chapter 3 of the book.
As I'm reading... I was wondering is it different SQL Server 2000 vs
SQL Server 2005/2008? Also
where can I find a book/or link that can give me more details about
the internals on architecture?
norm (email@example.com) writes:
> Hi I have a book "inside SQL Server 2000" by Kalen Delaney, which I
> have been told is a good book. I am g...File Size problem #2
I have a simple spreadsheet that started out 1.5 MB....then I starte
adding working sheets and VLOOKUP's.,....next thing I know it come
back saying 7 MB. I went back and copied, paste special, values of th
results of the VLOOKUP, but still the file size did not go down. I
should since I am virtually going back to the way it was in its 1.5 M
form. How can I reduce file size?
Thanks for any advice......
Message posted from http://www.ExcelForum.com
"gacollege >" <<firstname.lastname@example.org> wrote in message
news:gacollege.10a6rk@excelforum-no...RMS 2.0 Manuals
Are there user manuals in .pdf format for SO Administrator, Manager and POS?
My client just purchased 8 v.2.0 licenses and would like to have the correct
manuals. Everything on the MS website still seems to say v. 1.3. Was v.2.0
released in February 2007? Why haven't manuals been updated from 1.3?
This is a multi-part message in MIME format.
Look on the 2.0 CD or they can be ordered by your Partner for ~$25.
i have to program an application which should do the following
1. Receive the binary data on 2 channels.
2. each channel will store their corresponding data to a common file
(july4.text) (each day 1 file will be created)
3. Each day the data received will be close to 30 MB of raw data (thought
SQL will not be appropriate for this)
4. The data which is stored in a file will have around 5000 parameters.(ie:
5. MFC application to read/parse the specified data(queried like june20th to
july2nd) and display it in graphical manner.(MS Chart?)
6. The parameters ...Moving customizations from SQL 2k to SQL 2k5 CRM
This may be a non-issue but I wanted to check to see if anyone has done this
and ran into issues.
I have the XML customization files from our previous install of CRM 3.0 with
SQL 2k database. I now want to import and publish these same customizations
to CRM 3.0 on SQL 2k5.
Has anyone done this or can point me to documentation that tells about the
success or issues for doing this?
On 7 Feb., 06:35, Chris Treanor
> This may be a non-issue but I wanted to check to see if anyone has done this
> and ran into issues.
&...Address List Issue #2
We have created two address lists on our Exchange Server 2003. But the
problem is that the members of one Address list can only see the other
Address List members and not the members of the address list to which they
This happens only when the Outlook 2003 is configured
in cache mode on the client side. If its not cache mode it is working fine.
We have single AD domain and single forest.
Address lists or distribution groups?
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"Haroon Mali...Outlook 2007 Beta 2
I have seen many comments reguarding this question but I still do not
understand how to fix it.
I have 3 email accounts:
They are all with the same ISP. My default is email@example.com.
When I send an e-mail out of firstname.lastname@example.org I want the return address to default
to email@example.com not my default firstname.lastname@example.org. To me the only time I would want it
to default to email@example.com is if I was a business. How do I send an e-mail with
the current accounts e-mail address without having to click on accounts and
Outlook knows about your default account and uses that for n...Meeting Requests do not display properly
I am hoping that someone may have seen this problem
before. When any of our users with Office XP send a
meeting request in Outlook, it does not display properly
for recipients that are using Office 2000. Any clues?
...CRM 3.0 Install Error with SQL Reporting Services and SQL 2005
Doing a CRM 3.0 Server installation. During the last page of the install
wizard (or what I assume is the last page) when I goes through and does
verification I get a red X next to SQL Reporting Services. The message I
receive when I look at the details is:
The specified path is not a metabase path.
Parameter name: path
Now SRS is installed and working. I put in the URL:
http://<servername>/reportserver and every other variation on that I can
also assuming you did not use ssl...
=======================...sql summarizing help
id, cdate, weeksago, amount, typeid, timeclose
496, 2010-02-11, 0, 450, 3, 1
490, 2010-02-01, 1, 200, 4, 1
491, 2010-02-01, 1, 350, 2, 2
493, 2010-02-01, 1, 500, 5, 1
489, 2010-01-21, 3, 150, 2, 1
136, 2010-01-12, 4, 500, 3, 2
137, 2010-01-12, 4, 100, 3, 1
138, 2010-01-12, 4, 500, 2, 1
1. i'm trying to create a sql that will give me a summary resultset grouped
2. i want to sum the columns and get counts based on typeid.
3. avg of timeclose
here's the sql i have:
, (sum(timeClose)/(count(timeclo...Vlookup help #2
I have two worksheets. Sheet 1 contains a number in column A and a name in
column C. On Sheet 2 I put my data from a csv file.
What I would like to do is vlookup Sheet 1 column C from the information on
Sheet 2 and return the number in column A that is associated with the name in
Sheet 1 Sheet 2
A B C A B
33 N6-270-15 N6-270-75 35
34 N6-270-30 N...SQL 'for xml' and C# example??
I'm missing some piece of the puzzle. I'm using 'for xml' type queries from
SQL2K - and now trying to change the front-end from ADO to C#, I can't quite
figure it out..
It seems that I could use an XmlReader.. and somehow use that instead of a
DataReader.. but that didn't work.. I tried using a DataReader and get the
byte array - but that wasn't right.
SQL returns formatted XML, I need to load that XML into an XmlDocument
somehow without ANY molestation of that dom. Any ideas? Examples? Missing
THANKS!! I've been looking for the answer to ...Update multivalue field in table from form with SQL
Access 2007 on Vista
I am using a form to establish the variables for a report before it is
created. One field on the underlying table is a multivalue field, and the
form includes a multi-select combo box control. After selections are made and
the OK button on the multi-select combo drop down is clicked, focus moves to
the next control. I have discovered though, that the underlying table does
not update immediately, but does so correctly when I close the form. This
sequence does not deliver the proper report data, so I need a way to
immediately update the underlying table (m...Refer to SQL statements globally
I have two large SQL statements that I need to use across several
forms, reports, etc.
Rather than repeat them in each form, I'm trying to store and
reference them globally.
For example, I'd like to store strSQL1 and strSQL2 in a global module,
so I can use either like this in a form:
Me!lstResults.RowSource = strSQL1
Me.Report.RecordSource = strSQL2
Would I just store the SQL statements in a global module like:
Public Function SQLSource() As String
Dim strSQL1 As String
Dim strSQL2 As String
strSQL1 = "SELECT blah blah...To SQL or not to SQL?
I have a very vertical product developed 100% in M/S Access. I developed it
myself in 1993 in the initial release of Access and been with it ever since.
It is currently very stable and running in Access 2003. My big question is
how or even *if* we should move it to SQL. My customers are getting bigger
all the time with more users. Typically our customers run one or two
workstations generally never more than 5. Performance, however, is starting
to slow with database sizes passing 500 meg. We also have a LOT of code
behind forms so are bound tightly to the Access development environ...ERROR: "The record you are requesting is currently unavailable"
CRM 3.0, using Web client, Windows Server 2003 SP1 for SBS.
Have found no good solution for this problem I've been getting since
installation couple days ago.
When trying to create a new appointment, upon save get the error:
"The record that you are requesting is currently unavailable. Either
the record was not found or you do not have sufficient security
permissions to view it."
Upon clicking "Ok" I get the error:
"General failure in scheduling engine" with a "Ignore and Save" button
which will save the appointment, but still marks the appointm...Tab Name #2
How can I display the tab name on a sheet? I'm looking to have a template
that pulls the name of the tab that I assign and displays it in the sheet.
Something similar to "&TAB" used in the Header and Footer option.
See Bob Phillips' site for formulas.
Gord Dibben MS Excel MVP
On Mon, 18 Sep 2006 13:58:02 -0700, Cantru <Cantru@discussions.microsoft.com>
>How can I display the tab name on a sheet? I'm looking to have a template
>that pulls the name of the tab that I assign and di...Skinning dialogs? #2
I have 2 questions about CDialog skinning...
1: I'm handling the OnNcPaint and OnNcCalcSize, but always when it is the
first time the window is drawn, when I click on the caption, it draws a
border around the caption, and then it doesnt happen anymore... No idea
2: How can I draw the Min/Max/X buttons also?
Hope you can help...
...PostgreSQL or other SQL servers in RMS
Has anyone successfully implemented RMS with one of the free SQL servers?
Theoretically, is there any reason why we have to use MS SQL Server 2000 for
"dh" <firstname.lastname@example.org> ha scritto nel messaggio
> Has anyone successfully implemented RMS with one of the free SQL servers?
> Theoretically, is there any reason why we have to use MS SQL Server 2000
> large databases?
RMS has implemented only for MS SQL Server (2000/MSDE) and isn't possible to
work with ano...writeback to SQL 2005
hello! I use excel 2007
iI open a connection agianst SQL server 2005 and choose a table. In my
workbook i can now see this data from this table. if i change a value in some
cell i wish to writeback to table in SQL server. Is this possible?
It's possible through the use of VBA and ADO, but not simply using the data
connection you've already established.
"CJ" <CJ@discussions.microsoft.com> wrote in message
> hello! I use excel 2007
> iI open a connection agianst SQL server 2005 and choose a table...Exchange 2003 Issues #2
I posted a little while ago with a question about a potential problem with
recipient update service and now I am not so sure this is the source of the
problem. Here is what's going on:
When I create a new user account and mailbox, nothing is being inheritted by
the new account. The email recipient policy is not filtering to the new
account nor is any permissions to the mailbox other than SELF. If I manually
set permissions according to a woeking mailbox, everything is fine EXCEPT,
the name is not appearing in the GAL.
I have increased logging on the Exchange Box and am gettin...