All Sorts Of Day Counters
Feb 21, 2005
i receive a date and hour in the past
and i've got to make an form who displays the next things:
total amount of days from received day till today (day may only update after the received hour)
total amount of months from received day till today (month may only go 1 up after the received day/hour)
total amount of years from received day till today (year may only go 1 up after the received day/hour)
(the DateDiff function is good but isn't 100% correct)
and at the end of the form i got to give an conclusion like:
XX YEARS and XX months and XX days (not the totals but exp: --> 2 years 3 months 5 days 7 hours 3 minits)
i hope to find out the time myself, if the other are correct
anybody did anything like this before?
can anybody help me out?
thx Killroy
View Replies
Apr 24, 2015
I have a union query of the Employees table and Dependents table on [Employee ID] which I build for a census report, and when I run the query, it sorts correctly, but it's not sorted at all on the report. I tried to add a sort on the group, but it just ignores it.
I need it grouped by [Employee ID], then sorted by [Last Name], then [Relationship], then [Age], so it will be alphabetical by the employees last name, then put the employee first, then the dependents by oldest to youngest. Is there a way to do this in the code, and where would I put that?
View 14 Replies
View Related
Nov 5, 2013
I am looking to modify this query to only show my records that have a "no" answer. I have tried to sort each column by using the Like "no", but that only sorts the first question. Is there a way to get all NOs from all 68 questions in one query to work with trending?The goal is to be able to show what questions are trending with an answer of NO, in Desending order by question. So then I would in theory have a report that shows trending questions with the answer "no" in order of greatest to smallest.
View 6 Replies
View Related
Nov 2, 2014
I have a continuous form that is used as a sub form, and one of the fields is a check box which ideally I would like to set not visible; however, I would like the font colour of the other fields to turn red if this check box has a value of false.
View 9 Replies
View Related
May 24, 2014
I am creating a Machinery database to match parts up with equipment. So they can see what the Equipment is and all the available parts. The sort needs to be like this
First Sort:
If the manufacturer of the machine is the same as the manufacturer of the part sort that at top then sort alphabetical
Is this possible? Each equipment would have a different manufacturer so I can not do some type of hard coding.
View 1 Replies
View Related
May 2, 2013
I have a form, with three different sub forms on it. Rather than us the record counter at the bottom of the subforms, i'm creating my own using this code:
Private Sub Form_Current()
Dim rst As DAO.Recordset
Dim lngCount As Long
Set rst = Me!subform.Form.RecordsetClone
[code]....
which works fine. But if I want to count the records in two subforms, how does that work?! I've tried copying and pasting the code again, but I just get an error
View 5 Replies
View Related
