Adding Up Durations (1.15 As 1h15m)

Nov 18, 2004

I have been asking this question couple of times but I don't think I am making myself clear. Here it goes again. I am tracking meetings that happend. With other fields, the meeting also has a "Duration "field. in that field how long the meeting lasted is entered. for example if it took 1hour and 15 minutes the user enteres 1.15.

Later, I have a report that displays meeting for selected dates. like the following

1/1/03 1.15
2/2/04 1.30
2/2/02 2.45

I want to add all the duration together for example if we add the above durations we get 5.30 or 5hr30min.
The way I have it not, it sums it up as regular numbers so it sums it up as 4.9

any suggestion would be appreciated.

View Replies


ADVERTISEMENT

Adding Time Durations

Jul 29, 2005

hi
i've got a time duration field that is formatted as a string. I want to be able to sum up the durations as i group the records in different ways. I can't convert it to time, because it changes the durations to a time value, not duration example: 12:29pm instead of 0:0:21
is there any possible way to work with time durations??

thanks
*j

View 4 Replies View Related

Adding Across A Row

Jul 14, 2005

Hey guys I'm developing a DB to input satisfaction surveys and compute satisfaction levels expressed as a percentage. I am setting up the DB with 1 record=1 satisfaction survey. The record would contain the fields:Survey Quarter and questions 1,2,3, etc. The responses to the questions are in pulldown menu form with Yes, No and N/A. I've already set Yes to be read as 1 and No as 0. Now I want to add across the row (Questions 1-11) so I can complete the math and get a percentage for each survey. So far I have had zero luck accomplishing this. Any suggestions?

View 4 Replies View Related

Adding Up

Feb 20, 2007

This seems really silly but I cannot get this query to work.

In one table I have the agents name, id,Category, No of held emails and the time it took to put these emails on hold. In the other query I have the same agent details,category, No of reassigned emails and the total time it took to reassign these.

What I want the query to do is add the total time spent holding and email to the total time spent reasssigning by category.

What my query keeps doing, as I thought it would be as simple as adding them together is instead of ie:

130+1 = 131 it gives me 1301?????

The query is joined using Agent id and Category.

Help Please:

View 6 Replies View Related

Adding Items...

Apr 7, 2006

I've made a button on my form which adds a booking ID into the listbox, but it doesn't seem to work. This is my code:

Private Sub Command18_Click()
Dim BoI As String

MsgBox "Booking successfully added!", vbInformation, "Booking"

If Month(Me.Date_1) = 1 Then
ListJ.AddItem Me.BoI
ElseIf Month(Me.Date_1) = 2 Then
ListF.AddItem Me.BoI
End If
End Sub

If someone could tell me the problem, I'd appreciate it. Thank you. :)

View 5 Replies View Related

Adding Data

Apr 12, 2006

Another simple question

I have 2 fields income and expenditure

i have a 3rd field disposable income

how do I get disposable income to automatically change when I input income and expenditure in a form

many thanks

View 6 Replies View Related

Adding Prices

Apr 28, 2005

ive got a database for tickets for a school play. how can i create a query that adds up prices from multiple records? would the total be displayed in a form?

View 1 Replies View Related

Adding Two Expression??

Jun 2, 2005

I Have a field that I need to manipulate the data in.

sample data follows [Field9]:

1 to 1 (cover page)
1 to 3 (no cover page)
etc..

this field identifies number of fax pages sent, eg
“1 to 1 (cover page)” is actually 2 pages, an attachment plus cover page
“1 to 3 (no cover page)” is actually 3 pages, 3 page attachment without cover page

What I want is just the total number of pages in this field.

I have written two expression that dissects the field in two, left hand side gives me a numeric number of attachments and right hand side a numeric value for the existence of a cover page or not.

Expr1: Mid([Field9],6,1)

Expr2: IIf(Right([Field9],15)="(no cover page)","0","1")

Each individual expression seems to do the right thing, but I have been unable to figure out how to add Expr1 and Expr2 to give me total pages.

Any help would be appreciated
J/

View 2 Replies View Related

Adding Dates

Jun 6, 2005

Is there a simple way to add 6 month to an unbount field based on a date that is already entered on a form? I have a field called Last PM and a field called Next PM - The [Next PM] value will be [Last PM] + 6 Months ????

Jon

View 2 Replies View Related

Adding A Short Cut

Jun 22, 2005

It is my first try at a access blank database. I have been ok so far but ran into this problem. All I want to do is add a sortcut on my desktop to open it to the database to the form I made BUT it opens up but i have to push on the name of the form to open up that form. I know there is a way to do it BUT can not figure it out . I do not need a switch board as the is only one form and that is not in my knowedge base It is like a custom
made directory

Thxs Steve

View 1 Replies View Related

Adding Zero's Before Number

Aug 30, 2005

I have a field where a user has to input numbers. This number at most will have 8 digits. Something like 00000001 or 00001234. I want access to show those zero's before the number but I can't do it. Any suggestions.

Thanks,
Yusuf

View 7 Replies View Related

Adding Records

Oct 10, 2005

This is probably an age old question but after a search I could not find the answer.
I have a table with 3 fields..... last, first, ssn
I have a form with 3 text boxes. I want users to input data into those text boxes and that data inserted into the table. The code I have figured out, the problem is access tells me I cannot add to the table because the controls do not have focus. Well, I can set focus to one control at a time but then that adds three separate entrees. Am I doing this the real hard way? Im sure there is an easier way to add records to a table with multiple fields.
Thanks

View 2 Replies View Related

Adding New Records

Oct 28, 2005

I have am building a program that requires a staff person to enter a daily activity report on employee activity. It's initiated by adding a new record
that will allow the selection of an employees name and ID number from a drop box into respective first name, last name and ID fields. The staff person would then go on to complete the daily report by adding information in several other fields.
My form is based on a relational query built from two tables; tblClient and tbldailyreport.

Any help would be appreciated.

Regards

Timber

View 1 Replies View Related

Adding New Record

Jan 5, 2006

Hi,

I've a quick question. In Access, I have a form that allows user to add new record into a table. Is there anyway of finding whether the new record has successfully been inserted or added?

So i think it may be wise to have a message to notify us of whether it's inserted successfully or not.

Hope this explain clear

Thank you very much in advance for your help

View 1 Replies View Related

Adding Subdirectories?

Feb 8, 2006

Hi, is it possible on the database window to add subdirectories? Such as in 'User Queries' under the 'Queries' tab, etc. If not, is it possible to add anything else to that ojbect window? I know you can add groups, but I need a way to split up queries and tables for individual users. Any help would be appreciated. Thanks!
Paul

View 1 Replies View Related

Adding A Hyphen

Feb 10, 2006

Can someone give me an easy way to put a hyphen between two numbers, such as with wins and losses of teams? I want it to come out 5-3, not 5 3.

I tried entering a text box with no success.

View 3 Replies View Related

Adding References Necessary?

May 9, 2007

Hi guys, ive been developing a database for someone. As some coding has been involved, I have added some references etc as I went along.

I'll be soon handing it over to them to use - will they have to add the references for the database to run on their comp? If so, is there more user friendly way of doing it than going into the VB bit etc?

Cheers...

View 3 Replies View Related

Adding New Column

May 17, 2007

Hi there,

I am trying to add a new column to my table say name2 with data type Text.
as soon as i hit save it gives me error
"Unknown function Date in validation expression or default value on Contcts.LastUpdated. (Error 3388)"

Any clue?

One more thing what is the maximum number of columns permitted in a table?

Thanks

View 1 Replies View Related

Adding New Value To Combo Box

May 31, 2007

hello,

I have 10 combo boxes on a form looking up at the same table (fileld A). I want the user to be able to enter a new value (that's not in the table and therefore neither it is in the combo box) to the 1st combo Box (let's say) and that same value to be automatically added to the table, so when I use the next (2nd one) combo Box, that same value is already in the table.

How can I do this??

Thank you very much

View 1 Replies View Related

Adding Reference

Feb 6, 2008

Hi,

I have an SDK that I normally use with VS.NET. I cannot seem to add the .dll as a Reference in my MS Access 2003 database. Is there something I am doing wrong, or a workaround to get it to work? I have .NET 3.0 installed on the PC.

Thanks,

View 1 Replies View Related

Adding Tables

Dec 20, 2005

I have a database that tracks staff training in a health trust. It's pretty simple, tb_staff, tb_courses_done which is 1:n and a tb_courses 1:n on the staff_id of tb_courses_done.

I want to know how to go about adding a table(s) that will allow me to book staff onto courses and track if they attended or not. At present it's 1 staff member has many courses so any courses entered are "done." I have a main form with staff details and it has a subform where I add completed courses.

Hope that's clear?

Thanks.

View 1 Replies View Related

Adding 2 Fields

Mar 2, 2006

Im doing a project at school and it involves adding 2 entities and then the answer being displayed in another entitiy i have searched the forums but with no luck is it possible at all.

View 1 Replies View Related

Adding Up Two Tables

Mar 30, 2006

Hello Guys

This might sound like an easy qestion but i just cant do it, and need someones help!

I got two Access tables that are set out exactly the same, and im trying too add the figures in both tables together, too produce the results in another table.

Can anyone help me on how too do this

Thanks

Mark

View 2 Replies View Related

Adding Strings Together

Nov 3, 2007

So I need to know this. How do I:

*Add 2 text fields together with a space between?
*Truncating field 1 to the first character and field 2 to the two first characters?


Sorry for my noob questions :D

View 6 Replies View Related

Adding Tax To Query

Mar 16, 2006

I have developed a query which adds accumulated costs for each client in my DB, I am having trouble adding the VAT tax which is 17.5% to the query though, I seem to get a lesser total once tax is added which can't be correct.

Here is my query:
SELECT DISTINCT Holiday_Bookings.ClientID, Holiday_Bookings.Booking_Cost, Room_Facilities.FacilityCost, Rooms.[CostPerNight], Rooms![CostPerNight]*Nights_Stayed+Holiday_Bookings!Booking_Cost+Room_ Facilities!FacilityCost AS TotalCost
FROM Room_Facilities INNER JOIN (Hotels INNER JOIN (Holiday_Bookings RIGHT JOIN Rooms ON Holiday_Bookings.ClientID=Rooms.ClientID) ON Hotels.HotelID=Rooms.HotelID) ON Room_Facilities.FacilityID=Rooms.FacilityID;

View 3 Replies View Related

Help Adding Something To This Query

Mar 23, 2006

I have a table called DSERDBA_CASE_STATUS_CHANGE and it contains the following fields:

DSERDBA_CASE_STATUS_CHANGE.STAT_CASE_ID,
DSERDBA_CASE_STATUS_CHANGE.STAT_BEGIN_DATE,
DSERDBA_CASE_STATUS_CHANGE.STAT_END_DATE,
DSERDBA_CASE_STATUS_CHANGE.STAT_FROM_CASE_STATUS,
DSERDBA_CASE_STATUS_CHANGE.STAT_TO_CASE_STATUS,
DSERDBA_CASE_STATUS_CHANGE.STAT_USERID,
DSERDBA_CASE_STATUS_CHANGE.STAT_ACTIVITY_CODE,
DSERDBA_CASE_STATUS_CHANGE.STAT_COMMAND,
DSERDBA_CASE_STATUS_CHANGE.STAT_REASON_CODE

I’m looking to find CASE_ID's where the BEGIN_DATE is greater than 09/30/2005 and less than 10/01/2006 where the CASE_STATUS went from O to C and where the STAT_REASON_CODE does not equal INT27 and I have come up with this query which works fine.

SELECT
DISTINCT
DSERDBA_CASE_STATUS_CHANGE.STAT_CASE_ID,
DSERDBA_CASE_STATUS_CHANGE.STAT_BEGIN_DATE,
DSERDBA_CASE_STATUS_CHANGE.STAT_END_DATE,
DSERDBA_CASE_STATUS_CHANGE.STAT_FROM_CASE_STATUS,
DSERDBA_CASE_STATUS_CHANGE.STAT_TO_CASE_STATUS,
DSERDBA_CASE_STATUS_CHANGE.STAT_ACTIVITY_CODE,
DSERDBA_CASE_STATUS_CHANGE.STAT_COMMAND,
DSERDBA_CASE_STATUS_CHANGE.STAT_REASON_CODE

FROM DSERDBA_CASE_STATUS_CHANGE

WHERE
(((DSERDBA_CASE_STATUS_CHANGE.STAT_BEGIN_DATE)>#9/30/2005# And
(DSERDBA_CASE_STATUS_CHANGE.STAT_BEGIN_DATE)<#10/1/2006#) AND
((DSERDBA_CASE_STATUS_CHANGE.STAT_FROM_CASE_STATUS )="O") AND
((DSERDBA_CASE_STATUS_CHANGE.STAT_TO_CASE_STATUS)="C") AND
((DSERDBA_CASE_STATUS_CHANGE.STAT_REASON_CODE)<>"INT27"));

My problem is that I also want to exclude cases where the case went from CASE_STATUS C to O on the same date that it went from O to C (it closed and reopened on the same day) And I don’t know how to adjust this query to accomplishment this.

Can someone show me how? Thanks

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved