SQL Select in a Module

P

Paul Dennis

Problem: I have a Table called PROBLEMS which list all helpdesk problem
tickets by an ITEM category. What I need to do for a given month is list the
ITEMs and then work out the total time the ITEM has been available.

I can work out the tickets raised in the month, and I can work out the
difference between the raised and resolved times. My problem is bringing back
the correct tickets to use to calculate the times since ticket B might of
started after ticket A but finished before ticket A finished hence would not
be used in the calc.

The only way I can think of to do this is to use a query to find the first
item and then to call a module which will use SQL with the where clause =
ITEM, but I don't know how to define the SQL to what I need and then loop to
select each row.

Any Ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Using Microsoft Access as a Service Ticket Write-up program 0
Print A For (docm), Send Email Attachment And Close For Without Saving 2
Excel Formula - If Cell contains word and select it from a list? 0
Using an ActiveX control instead of multiple Access controls 0
Look up one value and return multiple corresponding values 2
Setting language of a selected text in Office apps. 0
Help with user selectable data presentation 2

Top