Simple DateDiff query
Here it is:
I have a form which contains the opening date and the resolved date
and I'm trying to workout how many days it takes from opening to
resolution. Is there a way to write a sql query to do this? Or can I
write a formular in the table to show this? Or can I get a text box on
the form to tell me this and then feed this through onto the table?
I've been working on this all morning and would appreciate any help
you can give me.
...How to do automatic Web Queries??
I would like to be able to import data automatically from a web page without
having to type in the web address.
I can create the correct url path in a cell using a CONCATENATE function but
cannot create a macro which references to that cell for the url look up.
This is the macro as it currently stands
With ActiveSheet.QueryTables.Add(Connection:= _
.Name = "main.php?cid=5516"
.FieldNames = True
.RowNumbers = False
I have my users set to user access only on the core
security roles for activities, but when they try to assign
an activity it comes back saying they don't have the
correct permissions to assign. Since user access doesn't
work, what level of security do I need to set up so they
It does'nt matter what level of access you give to the core records
for activities, even Organizational Wide access will not allow a user
to assign an activity unless the user has a role which gives Read
access to 'Queues' as well.
Also, ensure that the 'Assign' level ...Result changes cell color
Is there a way to fill a cell with a color depending on the result?
Basically, I want the following:
If cell = 1 Fill cell with Red
If cell = 2 Fill cell with Yellow
If cell = 3 Fill cell with Green
Thanks for any help.
format>conditional format>easy from there
"GSBohn" <firstname.lastname@example.org> wrote in message
> Is there a way to fill a cell with a color depending on the result?
> Basically, I want the following:
> If cell = 1 Fill cell with ...Simple VBA question #2
Can anybody tell me why this isn't working? I have a list of Last names in
A2:A6 and a list of first names in B2:B6. It works if I put a match in cells
G6 and H6, but gives me an error if there is no match. Thanks for the help.
Dim a As String
Dim b As String
Dim c As Boolean
Dim d As Boolean
a = Range("G6").Value
b = Range("H6").Value
c = WorksheetFunction.IsError(WorksheetFunction.Match(a, Range("A2:A6"),
d = WorksheetFunction.IsError(WorksheetFunction.Match(b, Range("B2:B6"),
...Re: Ranking my results in a query to get the TOP#10 percent
I have created several queries and now I would like to rank my result to
only get the TOP 10 percent.
Could you please assist me with an Access SQL statement that can accomplish
SELECT TOP 10 PERCENT *
ORDER BY someExpression
It is not a 'rank' in itself, though, just a pick of the 'top most'. Light
difference between the two expressions, but it probably does not matter...
Vanderghast, Access MVP
"TL" <TL@discussions.microsoft.com> wrote in message
news:E6549C8D-9FDC-4568-B73F-434BAF601BD7@mi...Search multiple sheets, then paste results in new sheet
I searched the web and newsgroups but couldn't find a way
to do this. I would like to search multiple sheets in a
particular column and paste the complete row containing
the searched word into a new sheet.
For example, suppose I have 2 sheets (sheet1 and sheet2),
each containing 3 colums (item_number, description, brand).
I would like to search for all items that are Acme brand,
and have the results (complete row) pasted into a new
Anyone know how this can be done? I would truly appreciate
any help with this.
Dim sAdd as String, v as...Wrong data is presented after query
The data base consists of 2 key reference tables Scanner Models and Scanner
Parts. As this is a many-to-many relationaship and there is a linking table
ModelPart. A third reference table holds Scanner Makes which has a
many-to-one relationship with the Scanner Models tables.
When work is carried out on customers Scanner a Service Report is input.
The Service Report consists of a main form (recording dates, work done etc)
and a subform (to enter details of parts used). The JobNo (Service Report
number) is the Master Link Field and Child Link Field
On entereing a service r...Global Variable -- Excel / VBA
I currently have a module in VBA that has 6 macros in it. In the third macro
I search down a column that was populated in the second macro. When I
encounter an empty row, I go back up one row and call that row ticker_end
(ticker_end = ActiveCell.Row).
However, when I got to macros 4-6 they don't recognize ticker_end and I have
to search through the column again for the condition I want and re-name the
variable at the start of each macro.
Considering that I can't create the variable before macro 3 because it
depends on actions in macros 2, is there some way once I do set ticke...Need a simple Secretaries Cash Book
I am trying to set up a simple secretaries cash book that would show cash
recieved, cash paid to treasurer and warrents written. I need a few accounts
for reciepts and disbursement tracking and running totals. Any Idea what
would be the easiest way to do this. I am fairly decent using both Access
and Excel, but couldn't decide how to begin. The templates are a bit
advanced for what I want.
If you know MS Access then use that program. A database is what you should
use for any kind of transaction processing.
> I am t...Simple addition
I am new to this excel stuff and trying to get a total six (6) row
across (every other one) and cannot get it to work for example I a
using the following formula: =Sum(d7:f7:h7:j7:l7:n7) I am doing this a
rows c,e,g,i,k & m have other numbers and I want the end results to b
% of these two different totals!
Any help would be greatly appreciated!
The first set of additions c,e, g, etc. are coming out ok, but when
put the other formula in I am getting a number without any numbers i
the rows. Hope you follow what I am saying
Message posted from http://www.ExcelForum.com
your formula in ...Assigning Accounts should not assign cases and activities
Our Tech Support team manages cases. They lose track of the cases when we
assign Accounts because they don't own the account. We also have many people
with activities for accounts they don't own. They lose track of the
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&quo...Query Personal Address book -v- Contact list
If I have understood what others are saying about Outlook 2000, Personal
Addresses are .pab files and Contacts are .pst. I was not aware of the .pab
files. I have recently changed from Outlook Express to MS Outlook (2000) I
am running XP Pro and Office 2000. When I upgraded from OE I seem to have
the majority of my previously used contacts (some are missing for some
reason - especially the group contacts). I though I should be using
Personal Address so followed the following MS instructions:-
1.On the Tools menu, click Address Book.
2.Click New Entry .
3.Under Put this entry, click Pe...Quicker way to assign transactions to categories?
I imported the last 6 months of my credit card activity. Although some of
the transactions were correctly categorized, most were listed under the
1. Is it possible to setup money so that if I tell it , say, "Russian River
Brewing Company" is Food:Dining Out, it will automatically reclassify *all*
of those transactions as Food:Dining Out, or do I have to go through
one-by-one and select the correct category for every Russian River Brewing
Company transaction over the last 6 months? In other words, can I tell money
*once* what category a transaction belongs to...Save DB query results as XML file
I am trying to query a SQL Server database, retrieve the results as XML, and
save them to a file. I was trying to use the SqlXmlCommand,
SqlXmlCommandType.XPath and an xsd to query the database, and load the
results into a XmlTextReader. This works fine. But then I get stuck. I
don't want to DO anything with the data besides putting it into a file.
Should I be loading the results into a stream, instead? Then load the stream
into a string, to an XmlDocument, then .Save(...)? Or might a XmlTextWriter
have a role in here somewhere?
Can anyone give me a hint on how I should appr...assigning a task
outlook 2003 with sp2 O.S. windows xp HE
When I assign a task or when I receive an assigned task, the task is a
simple email message without the options to accept or refuse it; and i
cannot automatically add it to my task.
There is somthing I do wrong?
Thank You and sorry for my english.
Force rich text on the task item. Double click the addressee and change the
option from "let Outlook decide..." to "Rich text."
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal ac...Simple workflow for CRM3 wait timer
I want to create a workflow that tests if customer is reached and if not
sends an email at 7 days & 14 days after the account is created. I am not
sure if the workflow is correct. Would the second wait start at the 7th day
so I can get 7day & 14 day?
When account is created
Wait for 7 day(s)
Account.<Owner> = Joe Blow : User
Send Email Template1
Account.<Owner> = Jim Jones : User
Send Email Template2
Wait f...automatically assign value
My data includes 3 scores, then I have a query to add those scores together.
Entry # Performane Score 1 Performance Score 2 Performance Score 3
Total Performance:[Performance Score 1] + [Performance Score 2] +
[Performance Score 3]
My Problem is now that I have the total performance score I need it to
assign a medal award.
Total Performance = 275 (3 scores added - 92, 91, 93)
Say If a gold medal is between the scores 270 and 281 how can I make it
automatically fill in the award earned in a column next to the total
I have several me...Assigning a value to each unit
I'm trying to assign a value to each entry on an Excel spreadsheet.
Since I'm grasping at straws for a way to phrase my question, perhaps
it would be better to explain my intended use. I'm trying to designing
an incident command spreadsheet for fire department use, and want to
have each unit, such as an engine or ambulance, assigned a default
value (used for staffing). For example, an ambulance needs to have at
least 2 people to be used properly. Thus, I would like to have the
default value for an ambulance be 2. I'm also calculating the total
number of people (minimum staffing...Assign one number to a number range
-assign 1 to any number between 50 and 64
-assign 2 to any number betwen 65 to 79
-assign 3 to any number between 80-100
So that 62 (in column 1) will be coded as a 1 (in column 2), whereas 67
would be coded a 2 and 83 would be coded a 3.
In cell B1 put this formula and copy down..........
=IF(OR(A1<50,A1>100),"Out of range",IF(A1>=80,3,IF(A1>=65,2,IF(A1>=50,1))))
Vaya con Dios,
"Sue" <Sue@discussions.microsoft.com> wrote in message
> For example,
> -as...search folder Outlook 2003 giving incomplete results
I created a search folder in Outlook 2003 with the
criteria being show me message from or sent to a specific
person. I also used the browse buton to make sure I
selected all the folders including the deleted items
folder. When I click the folder it accurately shows me
the items I have sent to this person, but does not
display mail sent to me from them as recent as today. It
does display message sent from him a couple months ago.
The email address for him has not changed.
I'm puzzled, but it makes me nervous that I may not be
getting all the mails i'm looking for Unless I manua...Running queries via forms
is there a good tutorial out there on how to make forms that run queries and
reports? I've gotten all turned around on it all.
On Thu, 22 Apr 2010 13:53:01 -0700, Dragon <Dragon@discussions.microsoft.com>
>is there a good tutorial out there on how to make forms that run queries and
>reports? I've gotten all turned around on it all.
Well, forms don't "run" anything. You can use a reference to a form control on
a Query, and base a Report on that query. Crystal's tutorial might be a good
place to look, this is one of the techniques she d...How identify data of two coulams,Every cell count and show result
Q1. How identify data of two coulams
Q2. Every cell count and show result like
I need like
Coulam A Coulam B
I want to count like coulam B i have data in coulam A and like this
I have two coulam with name as lower,upper,propercase i want to do all in
same case like in proper case how?
In column B enter
How do I make every thin in a column that is not >4000 assigned the "0" and
every cell >4000 assigned the "1" (and ignoring the letters)?
column might look like
Message posted via http://www.officekb.com
Are there always just 2 letters (or none)?
On Tue, 07 Jun 2005 17:32:03 GMT, "jeremy via OfficeKB.com"
>How do I make every thin in a column that is not >4000 assigned the "0" and
>every cell >4000 assigned the "1" (and ignoring the letters)?
&g...Removing queue read privilege: assign to another user
If you remove the Queue read privilege from a security role then you would
expect the users assigned this role to:
- Not see the queues area on left Nav
- Not be able to assign records to queues
- BUT, they should still be able to assign records to other users
The final point above is not the case. You get a permissions error when
trying to assign to a user.
To explain another way: Take the “Customer Service Representative” out of
the box security role. Change the Queue read privilege to none. Give a user
just this security role and they will not be able to...