Recent content by Kelly

Thanks CanadianAccessUser. I'm a complete novice though so I am unsure exactly about your code. I have tried to make queries where I have changed the hh:nn:ss to seconds using an expression this seems to work, however I'm not really sure yet, my problem is a query to work out the percentage the...

Thanks I have looked at DateAdd before and cannot see a way it can relate to duration.

Hello everyone Need help and I cannot find the answer anywhere yet I am sure this is a common requirement for a lot databases. I am building a database to enter staff phone statistics. As an example my fields would be - Name, Date, Staffed time, Available time, Aux time and then calculated...

When I asked the question using the old thread the site said I was logged out, so I never realised it had posted my question. Sorry not up on forum etiquette.

I have a database of faults. Each fault has a Reference number to identify its location. I need a query to tell me when 3 faults have occurred within a 30 day period (rolling 30 days) and only show those records. The individual fault also has a reference number which will need tb shown on the...

Hi did you get any answer to this? I also need a query which will only show records that fall within a 30 day period. I actually need to extract the record if it has occurred 3 times within a 30 day period. It must be possible just not the ways I am trying. Can you help Thanks

My table looks like District NRN North Dist LV ref lv cust affected Min Stage Time TAY 003_ 005_ 010_ 06 0000274 12 30/05/2010 21:53:00 TAY 003_ 005_ 010_ 06 0000279 12 01/06/2010 06:43:00 TAY 003_ 005_ 010_ 06 0000282 12 02/06/2010 16:10:00 TAY 003_ 005_ 010_ 06 0000422 12 02/07/2010...

Is there a simple code/function I can use to extract a record and show in the reference column every third number. Basically I am getting the results on my query by using SUM - First or Last, however I dont want to see them I want to see the third number how can I change this? Please absolute...

Thanks but I'm looking for the query to find the record with the 3rd date so it can be found on a form which then will be updated. I am now thinking this could be done in a count query, somehow! Cheers

Hi I'm completely new to this and recently found myself given the task of investigating whether a database was the way to go. I have records which are a list of faults, two fields are duplicated and the third field is the date the fault occurred i.e 1 Glasgow 230002001 01/10/2010 13:30...

Hi I am looking forward to spending much time on this forum I feel a bit of a fraud though, I do not have anything to offer but all to learn. Cheers