Results 1 to 1 of 1

Thread: Complex query

  1. #1
    Join Date
    Apr 2004

    Question Unanswered: Complex query

    OK sorted
    My mate exported that data to excel and then from there he made all the necessary calculations

    Hi guys

    Is there a way I can generate a report that determine average turnaround of orders from time they are put on the db to the time they are typed up and dispatched.

    I have "submitted" & "dispatched" date fields in every record but how can I create a query/vba code which will tell me what is the average turnaround.

    Im not asking you to write that code for me I just want to know where to start and where I can find sample code for something similar.
    Any help would be greatly appreciated

    Last edited by Dugi; 06-08-04 at 06:11. Reason: problem solved

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts