Converting Numeric Values Into Time Values

Jan 15, 2008

I have a travel time database that should tally the number of minutes traveled and convert them into a time (hours and minutes). I, however, am having difficulty converting the numeric values cleanly. Is there anyway to convert 102 minutes + 100 minutes + 110 minutes = 312 minutes to 5 hours and 12 minutes cleanly? I need to take averages of time traveled and hours worked but cannot do this correctly. Thank you for any help in advance.:eek:

View Replies


ADVERTISEMENT

Validating Numeric Values!

Oct 15, 2006

How can I check if the user is entering numeric values?

I can do it in the code, i.e. the lost focus event to the text box but I want to make a check in the "validation rule property" of the text box...!! How is it possible??

Thanks

View 1 Replies View Related

Option Group: Help With Numeric Values

Apr 26, 2007

Hello,
I am not sure what cateogory to choose for this question but I would greatly appreciate your help.

I have 5 buttons in my option group:
1. very often
2. often
3. occasionally
4. rarely
5. never

I have to produce a report using description of each button in my report, not numeric value. I heard something about global variable but I am not sure how to do it.

Many thanks,
Debbie

View 1 Replies View Related

Getting The Max Value After Grouping Alpha-numeric Values

Jan 8, 2007

Hi,

I am trying to create a query that will return the max value of small groups of alpha numeric fields. The numeric portion is the same for a series/group of items, but the alpha increments. Example: (I color coded the numeric groups for ease of reading)

The following:

...
0001210-0015A
0001210-0015B
0001210-0015C
0001211-0001A
0001211-0001B
0001211-0001C
0001211-0001D
0001211-0002A
0001211-0002B
0001211-0003A
0001211-0003B
0001211-0003C
0001212-0001A
...

would have a query result like this:

...
0001210-0015C
0001211-0001D
0001211-0002B
0001211-0003C
0001212-0001A
...

Unfortunately, I do not have any other fields that I could use to help. I was able to create two calculated fields one with the numeric portion and one with the alpha portion, but then didn't know how to remove the unwanted ones. Also, every value is the same size, 7 numbers, one dash, four numbers, and one letter. My table has around four thousand records or so.

I thought of writting a VB app to single step and compare, but I am hoping there is a better method.

I have been pouring over this site and trying all kinds of things that end up failing. I am not a novice, but obviously not an expert.

Any help would be greatly appreciated.

Thanks in advance.

View 1 Replies View Related

Converting Null Values To Zero

Mar 30, 2006

Hi all, need some help. In my query I have 4 fields, a weekly labour cost, weekly material cost, weekly plant cost and a weekly summary. The problem I have is that my weekly summary shows a null value on some weeks as not all the weekly costs have a value assigned to them.

I have been told there is a way in the query to convert Null values to zero so that the weekly summary field doesn't show a blank cell.

Could someone please explain to me how this is done? Thanks

View 6 Replies View Related

Replacing The Numeric Values Of A Field In Querry

Apr 25, 2007

Hi

I am trying to replace the numeric values of a field with a text in querry using Choose function, something like this aa5:

Choose([a5]-1="one";[a5]-2="two";[a5]-3="three";[a5]-4="four")

But it is not giving me no results :(( I am missing something but I do not what. Maybe I should use some other function?

I hope someone will help me!

View 1 Replies View Related

Queries :: Numeric Comparison And Null Values

Sep 24, 2013

I have a form with a textbox, where one inputs a number and then I run a query with the form criteria. The query is

Code:
Select Blah blah from dbo_temp where A>textbox value OR B>textbox value OR C>textbox value OR D>textbox value

The columns which are linked to the textbox some times contain null values. So, A, B, C, D columns do contain null values.

The expression in the "Criteria" column of Columns A, B, C, D (all on different lines - to make sure OR criteria is fullfilled) is as follows

Code:
>IIf(IsNull([Forms]![MainForm]![Criteria]),-100,[Forms]![MainForm]![Criteria])

I've put in -100 as an arbitrary never possible number. Obviously, this does not return Null values.

Question: How can I return both Null & Numbers when the Textbox in the form is left blank? in all the columns. Currently, I am not getting Null values

Code:
>IIf(IsNull([Forms]![MainForm]![Criteria]),SHOW ME EVERYTHING INCLUDING NULL VALUES & NON-NULL NUMBERS,[Forms]![Material Finder]![txtPS])

or in other words

If the textbox is blank, show me all the data available, else if it is not blank then show me only the values that are greater than the number entered in the textbox from within column A, B, C, D ....

View 3 Replies View Related

Tables :: Different Numeric Values In One Cell Of Table

Jan 30, 2014

Is there a way to write different numerical values in single cell of table via form.

View 2 Replies View Related

Queries :: Report Returns Numeric Values

Jun 28, 2013

I am making a report off of a query. The report is returning values from a Option Group. 1=Yes, 2=No and 3=N/A. The report returns the numeric values and I want the value labels instead. So, I created a column in the query for exp1 which looks like the following:

=IIF([VSArrive]=1,"Yes",IIF([VSArrive]=2,"No","N/A"))

What the report returns is #Error.

View 6 Replies View Related

Forms :: Filter On Text And Numeric Values?

Oct 17, 2013

I've created a macro to use an unbound textbox to filter a form. In a query, I combined 3 fields to enable an easy search over. Sadly, only text characters work for the search, so whenever I search for numeric values, it returns null. This doesn't happen if I utilise the filter over just a numeric field - only when the search field combined multiple fields.

Is there a simple solution? My marco filter is

Code:
[Forms]![STAFF SEARCH FORM]![SEARCHDATA] Like "*" & "[SEARCHFIELD]" & "*"

View 1 Replies View Related

Problems Converting Null Values To Zero! Help!

Jun 26, 2007

Hi everybody,

Here is an example of a report where I'm having the trouble:

Client Name _____ Yr 1 ______Yr 2 _____ Yr 3

A ______________50_________47_______62
B ______________ __________30_______85
C _____________121_________ _______100


Basically what I want to do is put a "0" where the blanks are above (Client B Yr 1 and Client C Yr 2). The problem is that in the table where I have the data stored, Client B doesn't even exist for Yr 1. It just has data for Yr 2 and Yr 3. I'm running a crosstab query off of the table to generate the report so I can make yearly comparisons. Is there a way in the query to add a zero where there are blanks, or do I have to actually go in manually and create an entry for Client B in Yr 1? I've tried =IIf(IsNull([Amount in Year]),"0",[Amount in Year]) and things like that, but they haven't been working. Any ideas?

Thanks!
-Andy

View 7 Replies View Related

Adding Numeric Values In Design View Of Query

Mar 3, 2008

I am adding fields with numeric values in design view of my query. The only issue I am having is that the query is not showing totals when one of the fields does not have a numeric value in it. How can I show the total numeric value regardless of the null value? Thank you:cool:

View 1 Replies View Related

General :: Adding Numeric Values In A Field In A Query

Feb 25, 2013

I am writing a sports database and have a query that displays a seasons fixture list in a form. One of the fields shows the points from each game played. (either 3 for a win, 1 for a draw etc). I can not get these points to be added up and displayed in a form along side the fixture list.

View 9 Replies View Related

Queries :: Wildcards - Find Any Number Of Numeric Values

Oct 3, 2013

How do you search for any number of numeric characters using wildcards? The # symbol only searches for 1, and * obviously includes letters.

Example:
I have:
D1234
D3
D5336767
D123F

My search should only retrieve the first 3 values.

WHERE FieldName LIKE 'D[0-99999999]' does not seem to work.

View 5 Replies View Related

Sorting Table / Query - Ordering Numeric Values

Dec 30, 2013

I currently have records that end with a letter and 2 numbers. For example, A1, A2, ... , A10, A11. When I try to sort my table/query by these values, A10 & A11 come before A2. It seems that it is sorting by the first digit shown. Is there any way to fix this quickly within table/query properties so that this can be displayed in proper numeric order?

View 7 Replies View Related

Converting Access To Excel Has Commas Before Values???

Sep 6, 2006

Hi, I am converting a database from Access 2002 to Excel 2002 but when converted each value in the spreadsheet has the value ' directly before it. Is there anyway around this problem.

View 1 Replies View Related

General :: Toggle Option - Converting Values To Words

Oct 7, 2013

I have form using a toggle option with four buttons. The values are 1,2,3 & 4. How can I convert the values to read (in the table) as words instead of values.

Example
1=dog
2=cat
3=bird
4=hamster

View 4 Replies View Related

Sort Subform Records On Numeric Values Stored In A Text Field On Main Form

Sep 25, 2015

I have developed a database but have had difficulty with sorting data within subform of a main form. The subform displays the related tasks that correspond with main form that has been selected. Within the main form I have also created a text field that defines a particular sorting sequence of the tasks found within the subform which is titled Task Sequence. What I would like to do, is use the Task Sequence field to sort the order of tasks within subform. I have tried: IIf([ID] Is Null, 0, Val([Task Sequence])) within the Advanced filter/sort but either it shows only the first task defined in the Task Sequence or it wants to filter the main form and not the subform.

View 14 Replies View Related

Tables :: Converting Excel Table For Lookup Of Values Based On Row And Column Headers

Sep 3, 2014

how data is best structured in Access.I have a table of values (for instance: weight) and I need to be able to look up a weight based on the column header (age) and row header (height).How is this sort of data best structured and accessed in Access?

View 12 Replies View Related

Time Now Between Limiting Values

Mar 21, 2006

Need some ideas on how to detect if Time Now is beteen preset values.

It is in connection with a Machine Monitor system being I am probably going to be asked to develop.

Problem is night shift. They work normally 20:45 to 06:45 following morning

I will be accumulating elapsed minutes of shift and working minutes by running an On Timer event updating both values by 1 each minute providing certain criteria are met.

One of the criteria will be that machine is supposed to be working.

So I was planning to set a flag indicating Working Yes or No based on the Time Now being between start and end times.

This is fine for normal day working and normal day shifts but is a problem with Night Shift.

Ideas on how to handle welcome

len B

View 8 Replies View Related

Adding Time Values

Dec 29, 2006

I have a report that adds time for as many as six people. This isssue is when the time goes over 24 hours in total it drops the hours. The field(s) is formated in "short time" format.

Can anyone help resolve this???:confused:

View 6 Replies View Related

How To Compare Time Values?

Nov 15, 2007

Hi.
I need create a query that can compare different time values.
My time field format something looks like 12:59 PM.
And compare other fields that has +- 10 minutes from my input.
It means when I input 12:00 PM to the query inputt then it lists records that have times 11:50 AM and 12:10 PM.
But I don't know how to compare these..they are not natural numbers..but they aren't text niether..
I tried to do it
[Arrive_Time] + 10
[Arrive_Time] - 10
in the criteria..but..doesn't work.

View 4 Replies View Related

Recording Time Values

Aug 3, 2006

I Have a problem in which when I create a record I wish the record to automatically record the time it was created. I have achieved this by having a timerecorded field within the table and setting its default value to time().

later on I wish another time to be recorded. This time when the user selected an option box to -1 I wish the time to be stamped into another field. I have used this event procedure to write the time to another field.

Private Sub AOGCleared_AfterUpdate()

'Update Time

If Me.AOGCleared = -1 Then
Me.TimeAOGCleared = Time()
Else
Me.TimeAOGCleared = ""

End If



End Sub

however It records the original time of creation when the obtion box is selected. Can anyone please point me in the direction of how I get access to record this later time please ?

View 5 Replies View Related

Getting Values In A Real Time

Sep 17, 2006

Hi:
I try to get the value in a real time. There are two subforms inside a mainform. First user enters value into mainform. Than comes to subform1. And after that on the basis of a choice in subform1, the 2nd subform is open. In 2nd subform i create a listbox with that query.

SELECT [tbl_Events].[PPVVOD_Outlet] FROM tbl_Events WHERE [tbl_Events].[ticketnum]=[Forms]![tbl_PPVResearch]![ticketnum];

But it shows empty. [tbl_Events].[PPVVOD_Outlet] is a subform1

View 1 Replies View Related

Adding And Subtracting Short Time Values Together/changing Short Time Into Minutes

Dec 9, 2004

Hello again,

I think my subject heading explains it. How would you add or subtract two short time formatted values and produce a short time value? Also, how would you change a short time value into number minutes. (i.e. 5:30 into 330) Thanks!

G

View 1 Replies View Related

Change Values In Several Records At The Same Time

Oct 30, 2005

Hi all!
This is kind of a philosophical question :)

I’m doing some changes to a “CRM”-database, and need to make a function that changes values in several records in one operation. The problem is, I have now idea on how to approach this problem.

One example; I have made a simple invoice function in my db, which works well. But now I send a lot more invoices then when I made the function. I’ve made a form, which prints the invoices, and I can print several in one “operation”. How can I, in the same operation, also change the status of the invoice record so that it says “Printed”?

If you have any suggestions on the method e.t.c.? Thank you!
(I'm using Access 2000)

View 1 Replies View Related







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