Recent content by lars7

Hi, This should have been I changed this "(A.[Date Started] <= B.[Date Started]))" to this "(A.[Date Started] >= B.[Date Started])" and got better results: Sorry for the confusion. Tom.

Hi, I changed "(A.[Contracted Hours]<= B.[Contracted Hours])" to this "(A.[Date Started] >= B.[Date Started])" and got better results: Pay Number NI Number Contracted Hours Date Started Rank P00000021 NM0000011 37.5 10/10/1999 1 P00000018 NM0000011 2 01/01/2011 2 P00000019 NM0000011 2...

Hi Skip, I gave it a go and here is the result: Pay Number NI Number Contracted Hours Date Started Rank P00000021 NM0000011 37.5 10/10/1999 1 P00000018 NM0000011 2 01/01/2011 2 P00000019 NM0000011 2 01/10/2012 1 P00000020 NM0000011 0.25 01/10/2012 2 Here is the code I used. SELECT A.[Pay...

Hi Duane, The only one I have is date started but that can be the same for some records too. Thanks, Tom.

Hi Guys, I'm using the code below to rank groups of records in a query: SELECT A.[Pay Number], A.[NI Number], A.[Contracted Hours], Count(*) AS Rank FROM tbl1 AS A LEFT JOIN tbl1 AS B ON (A.[Contracted Hours]<= B.[Contracted Hours]) AND (A.[NI Number] = B.[NI Number]) GROUP BY A.[Pay Number]...

Thanks Skip, I have it working as a function now and hopefully i will understand it one day [bigsmile]

Hi Duane, I felt, in the example, I had shown that there was no dates involved but I hope Skip accept my apology for not being clear enough and I will try to be clearer in the future. Hi Andy, Yes you are correct; it is the second code example that added the colons. Hi Skip, Thanks for the...

Ok Thanks, Will have a look at that on Monday. Lars7

Hi Skip, I got it: Me.Hours = Abs(t2 - t1) * 24 thanks again

Hi Skip, Sorry I missed your amendment to the code, it works fine but how do I get it to populate the Hours Field? Thanks, Lars7

Hi Again, I tried your code from the after update event and i got a type mismatch error. Hovering over Abs in debug mode I got Abs(tl-t2)=8.333333333333333E4-02 thanks.

Hi Skip, This looks great but I'm unsure where it's to go. My current queries runs on the after update of the Time text box and also I was looking for the hours to go into another text box called "Hours" Thanks for your help.

Hi Skip, I've been asked to help with someone elses databse and they don't want to change there current practises so I'm working around what they have. The time is being recorded as 1200-2000 in a text field called "Time" and them I'm converting the data with this code...

Hi, How would I calculate the hours between to times ie, 12:00 till 20:00 = 8hrs Thanks in advance. Lars7

Hi PHV, Your code worked great. Thanks, Lars7