#### MS Access 2007 Query _ Report

```I have a table that consists of a field named Minutes, multiple entries for a
specific individual may occur for any given day. I am placing a calculation
in a query that will break the minutes into 15 increments by using the
formula [Minutes]/15. The result value is coming up in correct when the units
are rounded; however, some values are rounded up. Example follows:

Minutes for a specific record; 5, 90, 50 for the same day = .333, 6, 3.333
respectively.

In the report the total = 9.667, which should reflect 9 only; in the report
it rounded to 10

The next record reflect
Minutes for a specific record;45, 70, 50, 15 for the same day = 3.000,
4.667, 3.333, 1 respectively.

In the report the total = 12, which is correct as 4.667 + 3.333 = 1.

What is the best way to handle this so that total minutes are calculated and
reflected correctly? I did try changing the properties, it did not work.

--
stonewall1974
```
 0
Utf
6/5/2010 6:36:22 PM
access 16762 articles. 2 followers.

1 Replies
1771 Views

Similar Articles

[PageSpeed] 48

```On Sat, 5 Jun 2010 11:36:22 -0700, stonewall1974
<stonewall1974@discussions.microsoft.com> wrote:

>I have a table that consists of a field named Minutes, multiple entries for a
>specific individual may occur for any given day. I am placing a calculation
>in a query that will break the minutes into 15 increments by using the
>formula [Minutes]/15. The result value is coming up in correct when the units
>are rounded; however, some values are rounded up. Example follows:
>
>Minutes for a specific record; 5, 90, 50 for the same day = .333, 6, 3.333
>respectively.
>
>In the report the total = 9.667, which should reflect 9 only; in the report
>it rounded to 10

The term "Rounded" does in fact MEAN rounded to the *nearest* value; if you
want 9.667 to become 9.000, then you're truncating, not rounding. Would you
want 9.99999985 to become 9, or 10?

To truncate use the Integer Divide operator instead of dividing and then
getting a fraction - that is, [Minutes] \ 15. The backslash will return:

30\15 = 2
31\15 = 2
44\15 = 2
45\15 = 3
--

John W. Vinson [MVP]
```
 0
John
6/5/2010 7:29:33 PM

Similar Artilces:

Use of MS Dynamics CRM in Utility Billing
Hello Friendz, I was wondering if we can easily use Microsoft Dynamics CRM 3.0 for 'Utility Billing System and Print Presentment'. This also involves use of handheld devices for reading meters and bill presentment. In case you know about a better solution for this requirement, please share that with me. -- Regards, Dave Banerjee Cell: 0060 17331 4676 | email: IfThenElseEndIf@msn.com | IfThenElseEndIf@GMail.com That depends on what you mean by "easily" ;-) CRM out of the box will provide a great, flexible platform to quickly develop a robust business solution. Fro...

Access & XML
Anyone know of a decent Training Site for using XML w/ Access? A Client is willing (pay the cost) to send me to XML Training. I would be using SQL Server & Cognos (perhaps Oracle) XML Tables into Access. Then automating Reports to Excel. TIA - Bob ...

MS Office 97 to MS Office 2007
I have been running Office 97 pro on Windows XP because I do not want to loose the shortcut bar that came with 97. Thing is that I have been thinking about installing the 2007 version of Office that I have had but never installed yet for above reasons. Question is can I install the 2007 version over the 97 version and have it update the programs but keep the shortcut bar?? I know there are probably other shortcut bars or whatever out there but as I asked I would rather keep the 97 one if possible. TIA Microsoft has several Knowledge Base articles on running multiple...

Item usage report
Hello, I think it's very easy question; If we go to any item and click History we will sales for this item for monthes. Can I print this information? And may be there is a report for all items for sales by month? Thank you Vitali Go to Reports >Sales>analysis>SOP Inventory Sales Reports >-----Original Message----- >Hello, > >I think it's very easy question; > >If we go to any item and click History we will sales for this item for >monthes. >Can I print this information? >And may be there is a report for all items for sales by month? > &g...

MS Outlook 2007
I am running MS Outlook 2007 on a Vista home lap top. When trying to delete files (or folders) in the Deleted Items folder, I get a message that "the Folder is full" and the items remain. I "right click" on Deleted Items, select "Empty 'Deleted Items' Folder", and I get the usueal warning msg that states "Are you sure you want to permanently delete all the items and subfolders from the 'Deleted Items' folder?" I click on "Yes". I then get a second warning msg that says "The folder is full." The ite...

Brand New to OL 2007
Is there a way to subscribe to some of the conversations here using OL 2007? I have recently found these discussion pages and am reeling from all of the info, but do not want to go to the MS web site every time to look for something. I am new to the whole RSS, newsgroup thing, but learning every minute. You can subscribe, but it doesn't always notify you. Better is to use an NNTP client to read the groups. You can mark threads to watch or drag them to a mail folder (in OE) to review later. If a thread has an answer and you want to save it, create a folder in Outlook then copy a...

Difference between MS EPM and MS Projects
What is the difference between MS EPM and MS projects Is it just project server and sharepoint added to MS projects together called MS EPM? Yes. EPM is Enterprise Project Management. Microsoft's solution is Project Professional plus Project Server which in turn uses SharePoint technology. -- Rod Gill Microsoft MVP for Project - http://www.project-systems.co.nz Author of the only book on Project VBA, see: http://www.projectvbabook.com "Project Mgt Noob" <Project Mgt Noob @discussions.microsoft.com> wrote in message news:A565E3DF-A7FC-4D2A-B2F1...

MS Exange connection
It deals with Outlook 2003, running under Win XP home: A friend has two ISPs, one with standard POP and SMTP servers, no problem there. The second is a remote MS Exchange server. He connects to both via Internet using ADSL connection. Question: how to configure the Exchange server connection such that it remembers his ID and PW? I could not find anything under just about any thinkable tab in Outlook, email accounts, etc. Any help will be greatly appreciated. -- JanAdam ...

How do I do word count in MS Publisher?
Mike, Publisher doesn't have a word count; the work-around wound be manually count the words or you could try copy the text and paste into Word. -- Don - Publisher 2000� Vancouver, USA "Mike Finn" <Mike Finn@discussions.microsoft.com> wrote in message news:9EBF3083-D7EC-46E9-ADA2-E4616499399E@microsoft.com... > Why not just do a "Edit Story in Microsoft Word" instead of copy and paste? -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Don Schmidt" <Don Engineer@PNB.Retired_...

How do i access microsoft excel on windows xp? #2
I recently purchased a pc that came with windows xp home. I thought the microsoft excel programme would come with it, but i can not find it anywhere. Does this mean i have to purchase it seperately? Yes; or as part of Microsoft Office. "ayanda" wrote: > I recently purchased a pc that came with windows xp home. I thought the > microsoft excel programme would come with it, but i can not find it anywhere. > Does this mean i have to purchase it seperately? ...

MS CRM Certification question
Hi all, I have a question regarding the CRM certification? What, if any, certifications are there available with MS CRM? Is there anything like CRM Professional? Have I earned any certification if I passed the Applications Professional exam? T.I.A -- Kuba Skalbania [MCAD] ...

publisher 2007 printing
I preview a page, it looks great, but it won't print any of the borders around text boxes. Any ireas?? brian wrote: > I preview a page, it looks great, but it won't print any of the borders > around text boxes. Check the website of your printer manufacturer for an updated printer driver. -- Ed Bennett - MVP Microsoft Publisher http://ed.mvps.org "brian" wrote: > I preview a page, it looks great, but it won't print any of the borders > around text boxes. > Any ireas?? Brian, Right Click on the text box and choose edit text box. There are choice...

MS Money 2005 Basics
I am new to MS Money after many years with Quicken. Money help offline and online, seems woefully short of detailed explanations o user scenarios. . Searching help for "Epay" yields nothing. Ca someone either direct me to a better help area or answer this In Bills what is the difference between Epay, APay, and Direct debit I see Apay is how i use the bill pay service of my bank. Is direc debit just my manual entry? What then is Epay? What might "Other payment type then be used for? Thanks The difference between them is this Epay is for electronic bill pay. You must have Bi...

Problem with TransferSpreadsheet in Access 2007
I'm having a problem with the TransferSpreadsheet method in Access 2007. The TransferSpreadsheet method is exporting a query to Excel, and it has been working fine under Access 2002. Under 2007, however, Access seems to truncate up some of the query column names, with the result that Access doesn't recognize them and prompts me for values for those columns. The problem is reproducible, occurring on the same columns every time. If I open the query directly the column names are fine and it exports to Excel with no problems; it seems to happen only with the TransferSpreadsheet meth...

exchange 2003 email access
Can I setup exchange 2003 clients to login to it as apposed to being authenticated by the DOMAIN? I have two domains in diferrent locations but want to share one exchange and accessed by IP address as apposed to the computer name. Thanks, Raul Rego rrego@njpies.org Can you explain what you're trying to achieve a little more? Are you trying to get users from domain A to access an exchange server in domain B? "Raul Rego" wrote: > Can I setup exchange 2003 clients to login to it as apposed to being > authenticated by the DOMAIN? > > I have two domains in di...

Copying an Entire Outlook Email in 2007 (Ctrl-F in Outlook 2003)
I recently upgraded from Office 2003 to Office 2007. When I created an email message in Office 2003, I could hit Ctrl-F and it would copy the entire email and create a duplicate of the original email. In Office 2007, when I hit Ctrl-F the find function opens. Is there any way to copy an existing email and create a duplicate but separate email in Office 2007? The alternative is to create a new email, copy the text in the original email and paste it all into the second email. This is much slower. Using a mail merge is not appropriate because I have to put a unique attached fi...

MS Access
Why doesn't MS support MS Access for Macintosh? Since I work in an educational environment that's mostly PC with MS Office begin the main suite, it would only be logical that since the PC version of MS Office contains MS Access for database entry, the Mac version of MS Office would also have MS Access. In article <BE09D66D.5FB8%redclawx@hotmail.com>, Red Claw <redclawx@hotmail.com> wrote: > Why doesn't MS support MS Access for Macintosh? Since I work in an > educational environment that's mostly PC with MS Office begin the main > suite, it would only ...

Access 2003 >> Access 2007 (Run-time error 2467)
Hi. I'm trying out how our access 2003 applications work in access 2007. Unfortunately, lots of forms refuse to open. Where the error occures is Form_Current event, which contains something like std = "SELECT ....." Me.Subform_Name![Field Name].RowSource = std The program reports an error: "Run-time error '2467': The expression you entered refers to an object that is closed or doesn't exist." Anyone has any ideas how to fix this? Technically, that shouldn't work in Access 2003 either, but it wasn't quite as sticky about the syntax. To refer t...

Hi all, I got a problem when i try to send message, the error message as below : Your message did not reach some or all of the intended recipients. Subject: testing Sent: 29/7/2004 11:55 The following recipient(s) could not be reached: 'support@xxx.COM' on 29/7/2004 11:56 The recipient name is not recognized The MTS-ID of the original message is: c=US;a= ;p=xxx (HK) Lt;l=xxxEX01-040729035523Z-29495 MSEXCH:IMS:xxx(HK) Ltd.:TDHK:xxxEX01 3554 (000B09B6) 554 <xxxex01.xxx.com>: Helo command rejected: Access denied ...

Hi all, In my client pc's i have configured the Microsoft office outlook 2007 after the configuration inbox mails are visible in inbox but sent items and other folders are not getting downloaded, my mail server is squirrel mail ,so please let me know the reason . POP3 or IMAP? "xpmate" <sreekanth.chn@gmail.com> wrote in message news:41cb29fe-c615-44b3-aa86-ea3eb607e2a5@g22g2000prf.googlegroups.com... > Hi all, > > In my client pc's i have configured the Microsoft office outlook > 2007 after the configuration inbox mails are visible in in...

Starting MS Outlook on startup
How can I start Outlook on startup (XP) and keep it running in the back? >-----Original Message----- >How can I start Outlook on startup (XP) and keep it running in the back? > > >. > All you need to do is move the Outlook program icon to the startup group in XP. >-----Original Message----- >How can I start Outlook on startup (XP) and keep it running in the back? > > >. >Double click My Computer, go into the C:\Documents and Settings\User\Start Menu\Programs\Startup Place an Outlook shortcut into this folder and it will automatically startup when...

Access 2003 Report won't attach to an email message.
I have placed the following code behind a command button. DoCmd.SendObject acReport, "rptPO_EmailViewOnly", "HTML(*.html)", Forms!frmMain!sfrmPOMultiTAB!frmPOHeaderViewer!SupplierEmailAddress, "", "", "Purchase Order", "", True, "" The problem is once the email message is generated the report attachment is not added to the message. To try and fix the problem, I installed Office 2003 SP3. After that, the attachment worked but is not able to be opened, I get an error message "The operation failed due to network or ...

Restarting MS Money with a "correction" switch
This is a multi-part message in MIME format. ------=_NextPart_000_003B_01C3DDDC.D92AA4A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I currently use version 10 - 2002 Deluxe, and I need to startup MS Money = with a correction switch that I hope will correct some problems that I = have been having, but I can't seem to locate the post that talks about doing = this. Is it "msmoney.exe /s"? --=20 Russell (if replying, replace nospam with rpottharst) ------=_NextPart_000_003B_01C3DDDC.D92AA4A0 Content-Type: text/html; c...

Tractor Fed Labels in Access 2002 on Okidata ML591
I am trying to print Model Name, technical data, and serial number on one label for each unit we produce. We do about 200 per day. The Tools: Access 2002 and Okidata Microline 591. I create a table with the data, and one row for each label I want to print. The serial numbers are the only difference in each row. I created a Report in Access with the LABEL Wizard and defined all the parameters. I Load the label roll into the Okidata ML591 and begin to print. After 6 labels it skips 1.25 inches, throws off all the alignment onto the Custom Printed Label Stock and now I have to stop; reset t...

Alternative to Ms sql server 2005 express edition
Hello Everyone, Our server hosting providers are saying that our web site is running slow because we are using ms sql server 2005 express edition which is a free edition and had only a capacity of handling up to 4 GB data. And our database which we are currently using is now having more than 4.5 GB. Hence they recommended us to go for a paid one that is specialized edition workgroup and gave us the following link http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx to go through the comparison. The hosting providers says that it will be around 4500 rupees per month for ...