Access Homework

profiledevilmycry1

Access Question :

 

Calculated field query (with table JOIN): Find the ticket numbers and the users submitted the tickets, for those tickets that take more than 5 days to resolve (define a new field TimeSpent, which is the time resolved minus the time ticket was submitted). Sort the result in the order of largest to smallest on TimeSpent.

 

 

Data table used: TicketTbl.

 

 

 

The Access file is attached. 

 

 

  • 11 years ago
  • 5
Answer(1)

Purchase the answer to view it

blurred-text
  • attachment
    tech_support.accdb
Bids(1)