Search results

Many Thanks Cronk. I was able to use your code and after some alterations to suit my needs it works fine and does just what I wanted

Brilliant that looks like just what I needed thank you Cronk. I am away for a few days now but will try it when I get back and let you know if it works Thanks to all who offered help. It is really appreciated.

Jdraw Each employee is allowed to work a maximum 70 hours over conscutive days before having to take a 24 hour period off work. The purpose of the report is to allow a manager to look and see the total hours an employee has worked where the hours have been worked over consecutive days during...

Many thanks for the suggestions guys. I have tried many ways with query's but cannot get the result I want. As gasman say's how do I get the query to recognize sequential dates. My initial thoughts were to create a For Next statement nested inside a Do Loop. The Do Loop would loop through each...

Thanks for that Mark but I'm not sure that will give me the correct result. I'm trying to sum the time worked in the hours field where the first consecutive days worked appear then move down to the next set of consecutive days worked and sum them and continue this to end of the table so that I...

Hi all I have a access table which I hopefully have correctly attached a snapshot of here The dates will always be consecutive and span from current date - 13 to current date +13 I am looking for something that, in a report, will sum consecutive days worked only, regardless of the year week...

Thanks JHB that works justas I wanted:)

Could someone please advise how when creating a new Table using a CreateTableDef function I woud set the first field as a Autonumber field. Thank You

Brian that does the job very nicely. Thank you very much for your assistance.Much appreciated.

Sorry for the delay in replying I have been away for a few days without internet access. So to try and explain what I am looking for a bit better. We have units arriving everyday. In an Access Database table, each unit has a booked arrival date and booked arrival time. The actual arrival...

Thank you Brian for your quick reply. I suspected this may not be possible but as I said I do not have control of how the table I import from is laid out. As an alternative I have tried to calculate just the time difference between the booked arrival time and the actual arrival time but still...

Hi All I am looking for a formula that will calculate the Actual Arrival Date in column in D of the examples below. I have been searching this forum for quite a while now and have tried many different if statements of my own without success. Columns A – C are imported in from an Access table...

Pete tried your suggested code, works perfectly :) Many thanks Also thanks RuralGuy for the Quote

Pete Many thanks for quick reply I will try your suggestions in the morning. Much appreciated. St

This is my first posting on a forum so I hope it makes sense. I would appreciate any help available I run the SQL shown below from a form button using DoCmd.RunSql without any trouble. Table A is a yearly rota for team A. I also have table B for team B, table C for team C etc. INSERT INTO...