Calculate in SELECT
How do I get: SELECT ((127/153)*100) AS percentage
to return 83 (or so)?
select cast((127*1.0/153*1.0) * 100 as int) as percentage
DECLARE @Value DECIMAL(10,2)
SET @Value = CONVERT(DECIMAL(10,2), 127) / CONVERT(DECIMAL(10,2), 153)
SELECT (127 * 100)/(153)
Add a .0 to the 127.
SQL Server MVP
Author, "Expert SQL Server 2008 Encryption"
"Snedker" <email@example.com&...Help with DLookup
I have a DLookup function on my form and it works by finding the
information once I exit and then re-enter the form, it does not bring
in the information as soon as I enter the information in the lookup
=DLookUp("[Employee Name]","[Employee Information]","[Employee
ID]=forms![Timesheet Entry]![Employee ID]")
Does anybody know why it is not updating immediately?
All help is greatly appreciated
Where are you using this expression -- as the control source of a textbox?
More details about the form's design and how you're using the form,
please....Conditional Formating Help
I wonder if anyone could help me, I am after code for the following.
cell e6 = Keys Sent
Column f6 = Keys due
Column g6 = Keys received
What I want the script to do is if there is no value in g6 and todays date
is greater then the date stated in F6, then the cell turns red (prompt to
inform me that keys are late).
Use a CF formula of
"housinglad" <firstname.lastname@example.org> wrote in message
...Tricky Formula.. Please Help
I have created a time roster.. easy
in each day I have start,end and break deduction.. still no probs
I need to create an output formula for hours worked after a 16:00 from
the start and end range on a day. So in the roster it will still display
normal hours, however I will create a field for hours after 16:00. this
is for calculating a different wage rate.
See response in .programming
(remove nothere from the email address if mailing direct)
"Aaron H" <email@example.com> wrote in message
...HELP- error Outlook
What's this mean and how to fix?
in error dialogue box: "c:\program~1\micro~2
Abnormal program termination
...help diagnosing what's going on in ExchangeServer2000
I'm fairly ignorant of exactly how ES2000 works and would like some general
information to help in my diagnosing why some emails are not being delivered
to certain email domains (more correctly, why some emails are not being
forwarded actually...ES2K is part of a voicemail system where some users have
..wav copies of the voicemails forwarded to their various off-site email
Here are my questions:
1. How can I see what emails are being forward? Is there a file/folder akin
to the SentItems folder in Outook?
2. If there are send failures, where can I find them and how can ...Need a Pause in a macro
I have a macro that goes out and retrieves data from a text file opened
with Excel, then pastes the data back in my worksheet and closes the
text file back up. For some reason, the data that is being brought in
is being inserted in multiple columns because it is using a space
seperator now in lieu of a tab seperator. Anyhow, if I go into my
macro and remove the part that closes the file I'm retrieving the data
from everything still works??? However, that file won't close. Is
there a line that I can add to my macro to allow a pause for things to
get caught up before the workboo...Noob Question For Selecting Multiple Fields On A Form
In versions earlier than 2007 I would be able to go to the Menu Bar and
click Edit -> Select All to select all fields on the form.
Now, my question is... where in 2007 did the put that functionality? If
Microsoft removed it from there... where did they recreate it?
"SQLSQUIRREL" <SQLSQUIRREL@discussions.microsoft.com> wrote in message
> In versions earlier than 2007 I would be able to go to the Menu Bar and
> click Edit -> Select All to se...Urgent Question Please Help: Credit Card Setup Problem
We have an urgent question regarding credit card setup/cash receipts/bank rec
We understand that in Great Plains when setting up a Credit Card to be used
by a Customer, it must be setup as a "Bank Card", not a "Charge Card", in
order for the transaction to hit Bank Rec.
However, we mistakenly setup all the Credit Cards as "Charge Cards",
therefore after posting Credit Card Cash Receipt transactions in Receivables,
the transaction does not appear in Bank Rec for us to perform Bank Deposits.
Please Please Help!!!
Is there any way to "fix" those pos...Conditional Statement in a Macro
I have a time sheet program with a pivot table on each sheet to sum the hours
worked on each job #. Each pivot table is named pivot table 7. I have set
up a macro to update the pivot table easily. It is as follows:
' Update_Pivot_Table Macro
' Keyboard Shortcut: Ctrl+p
Thus, since each table is named "PivotTable7" the macro works on any of the
I have added a pivot tab...Select non-consecutive rows
Is there a way to select non-consecutive rows besides Ctrl + click. If I
want to insert a blank row above about 40 rows, this can become quite tedious.
only possible with VBA in this case
"dee" <firstname.lastname@example.org> schrieb im Newsbeitrag
> Is there a way to select non-consecutive rows besides Ctrl + click.
> want to insert a blank row above about 40 rows, this can become quite
> Tha...help with unusual request
My boss has hit me with an odd request and I would like
to ask for someone to point me in the right direction.
What he wants is everytime anyone sends or recieves an
email that a copy is made that he can get to anytime he
wants. I talked to him about our daily backups, but he
wants something that's realtime and that he can get to
whenever he wants. I'm stuck and looking for ideas. We're
currently on Exchange 5.5 with all of the latest service
packs and patches. Any and all help is very much
You can enable "message journaling" fea...Help designing a checklist in access
My company currently uses excel checklists to ensure that projects are
completed fully. we have around 10 different checklists. each
checklist (excel file) has 6 sheets, each sheet 15 questions or steps.
most answers are Y,N,NA and the employees put their initials in the
correct answer column. Many questions are redundant throughout the 10
checklists. I would like to create the checklists in access because
their are too many excel files getting lost and if we change question/
step. we have to change it multiple times. the employees need to enter
a clients name and then choose the c...Why are checks printing incorrect amounts? Please help.
When I print a Payables check batch, several invoices within the batch are
printing incorrectly as $0.00 amount, even though it should be paying off a
The problem seems to be with invoices that are applied to credit memos. Say
I have an invoice for $500 and I apply a credit memo of $80 to the invoice,
when I go back to pay the invoice, it should pay $420, but instead it shows
$0.00 under amount paid column of check stub.
Does anyone know why this is occuring? By the way, I am using MICR check
...Timesheet Pseudo Tied Mode
I'm hoping that I might have a colleague out there who could help me
offline figure out how to install this open source utility
(unsupported by Microsoft but apparently works OK for some of their
clients) that streamlines the Timesheet process (automatically
synchronizes the data into My Tasks whenever a timesheet is saved).
I'm not sure where to start and may need someone to bounce questions
off of - especially if you've been successful with it.
We installed it (still using the version 1.3 based on event handler)
and we're usi...Please help with Exchange 2003 SMTP Connector
I'm trying to create an SMTP Connector in Exchange Server 2003, to have our
company's email sent out (Internet/External emails) to a specific mail
forwarder server (the "specific" server is our ISP/Firewall provider
server). But I'm having problems understanding how to set this up properly
with our Exchange 2003 Server, I know I have to create a new SMTP Connector
but not sure what settings to make. Could someone please help me with this.
On Thu, 25 Feb 2010 22:41:39 -0500, "Bill" <email@example.com>
>I&...Landscape selected but printout persists in portrait. How to fix?
Occasionally, I have had a spreadsheet I created in landscape layout revert
somehow to portrait. It still indicates that it is in landscape in the page
setup menu but it print previews and prints in poitrait. I've tried copying
the page to a new workbook, but it takes the portrait layout with it. Short
of manually moving all my data to a new worksheet, what can I do to get back
my landscape layout?
excel page setup settings are different than your printer settings.
sometimes one will override the other. i'd check them both.
On Dec 2, 1:22=A0pm, R.Lamki...Help in turning off underlining and blue font
Hello, Does anyone know if there is a way to turn off the automatic
underlining and blue font of the text when entering a email address in a
Tools / Autocorrect options / Autoformat Tab / Replace Network paths with
hyperlinks - Deselect it
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------...Help!!Getting audio files to play continuously during slide show?!
I have Powerpoint 2002, and i am having a hard time getting the music file to
play continuously during the slide show. it plays on the first slide (which
is the only slide that has the little speaker picture on it), but then it
doesn't transition to the next slide until after the song is done, when i
want the song to play while the slides are transitioning. HELP please!
Have a look here and see if it helps, there are tuturials in video
demonstrating the process.
MVP - PowerPoint
"MegaB86" <MegaB86...Help with counting formula
Sheet 1, Row 1, Column 2 - opening hours divide into
15min segments. B1 -
08:00, C2 - 08:15, D2 - 08:30, and so on.
Sheet 2 , Columns 1 and 2 - a list of each agents break
times. Column A -
Start time (eg 10:00) and Column B - End time (eg 10:30).
Sheet 1, Row 2, Column 1 - summary titles. (eg Cell A2 -
Problem: I need to summarise the number of agents away
on, say, "Morning
Break" per 15 min segment.
So, B2 must count the number of people on "Morning Break"
at 08:00, B3..the
number of people of people on morning break at 08:15, a...Please help! Outlook not working at all!
Hi! I have been working with Outlook for years - it was
always a great feature - but now it is critical since I
have an Ipaq that I need to sync to it.
Outlook somehow is no longer working/on my computer. I
have tried repeatedly to reinstall - to "fix" - anything
with NO luck. I get an icon to click on for Outlook and
then it goes directly to personal folders (nothing
actually happens). Every other component of Office 2000
is working perfectly.
Any help would be GREATLY appreciated! I am desperado!!!!
Have you run "Detect and Repair" from under help in Outl...Match() - Offset()
Often I see mention of Offset(), Match(), & Index() XL functions.
Could someone big-picture these functions for me?
I have not used these functions yet in data lookup or evaluation. Shame
That said, The concept of "Index" I understand from db work. "Match"
seems vaguely logical to me for "lookup" work. "Offset" means nothing to
Reading the XL help or reference books do not give me typical uses and
why's of the functions.
My focus is the accounting/financial world.
Using XP Pro & XL XP Pro SP1.
This file b...Reported error (0X800CC0F) the connection to the server was interrupted
I am receiving this error message on a client workstation, none of the
other 4 users on the LAN are receiving this error. They are using
Outlook 2002 connected through an ADSL modem.
The user still can send and receive e-mails but this error message
Any one have any ideas?
Reported error (0X800CC0F) the connection to the server was
For those of you that have been getting "Sending and Receiving reported error .... connection to server was interrupted" as I have, try creating a new HTTP email account, send and receive a couple of messages from that...How do I refresh the selection listboxes on a pivot table?
The field-level (column) selection boxes used to select the data to be
included in a pivot table include old and new values. How do I refresh these
list boxes so they only include values that are present in the current source
data? The list box continues to show values that are no longer in the data
Click in the Pivot Table to bring up the Pivot Table toolbar. (If that
doesn't bring it up, rt-click a toolbar and select it from the list.) Click
the button with the ! icon to Refresh the Pivot Table.
Hope this helps |:>)
> The field-level (colu...Help with XslCompiledTransform
I am using XslCompiledTransform to transform XML into Excel 2003
SpreadsheetML. In order to get the resulting XML file to open in
Excel, we need the following two lines at the top of the file:
I can get the <?mso-application ...> line by using an
<xsl:processing-instruction> element, but for the life of me I can't
get XslCompiledTransform to include the basic <?xml...> line. When
creating the XmlWriterSettings for use in the transform, I have not
altered the OmitXmlDeclarati...