Search results

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...

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...

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...

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