Search results

  1. R

    Hi arnelgp, How could I copy and paste all records from one table to another.? yesterday, you...

    Hi arnelgp, How could I copy and paste all records from one table to another.? yesterday, you helped me with resetting HSE incident count. After I having it done, the orginal table need to updated. If I have to use update the records, what shall be the parameter? Alternatively, is there any way...
  2. R

    Query required for adding formula in a field value2 = Value1 + 1 and so on....

    This is a typical first page of daily progress report starting with HSE Summary. The lower section shows the count of incident free days. The background of this report is the tracker in Access which I wanted to automate. Unless it is not set zero, the count of incident free days goes on till the...
  3. R

    Query required for adding formula in a field value2 = Value1 + 1 and so on....

    Thanks for your comments Cj_London. As I mentioned, the count of incident free days, injury free days is reset, manually, only when there is an incident, of course it does not happen each day and thats what we strive for. There are celebrations on project sites when we have 100 consecutive...
  4. R

    Query required for adding formula in a field value2 = Value1 + 1 and so on....

    Thanks for the suggestions plog.... Much appreciated. let me try working on it.
  5. R

    Query required for adding formula in a field value2 = Value1 + 1 and so on....

    Amazing.... Cheers arnelgp. You made my day. It works the way I desired. I will have the result of query copied using a macro to the table. Thanks again for the solutions suggested.
  6. R

    Query required for adding formula in a field value2 = Value1 + 1 and so on....

    Hi plog, Many thanks for your reply. I am looking forward to add this part of my Access tool which have several other simple queries to automate the report. Pls find attached db for your reference with a table. am using this tracker for the count of Incident Free Days on Construction Project...
  7. R

    Query required for adding formula in a field value2 = Value1 + 1 and so on....

    Nope, I am project controls engineer (Civil Engineer by Qualification). I am trying to automate the reports to the extent possible. I am require to reset the count manually, whenever any incident happens.
  8. R

    Query required for adding formula in a field value2 = Value1 + 1 and so on....

    Hi Arnelgp, Thanks for the suggestions, however it didn't work. Pls find attached database with the table with the content on which I have to apply the query. The password "STAR9999!" if required.
  9. R

    Query required for adding formula in a field value2 = Value1 + 1 and so on....

    I am using this tracker for the count of Incident Free Days on Construction Project which goes beyond 1 year in duration. In the event of any incident the incident free day's count becomes zero and count is reset to 1,2,3,... for the upcoming days. I want to automate in using access tool where I...
  10. R

    Query required for adding formula in a field value2 = Value1 + 1 and so on....

    I seek help from the experts in the forum. I have to add 1 to the consecutive values in a field as shown below, as shown in the table below. If I make any value in column- COUNT zero (manually) as highlighted, the count reset to 1,2,3,4,5,6..... Kindly suggest how to write the query in Access or...
  11. R

    Hello

    Hello Buddies, I am Rupesh, working as Project Controls Engineers. I am new to Access and learning Access to manage the database for my construction projects.
Back
Top Bottom