criteria

  • Thread starter Thread starter Jay Langston
  • Start date Start date
J

Jay Langston

I have a query set up to count the number of trouble calls for a certain
customer grouped by the initial installer. I would like the result to just
count the first trouble call after the installation, so that I could
calculate the number of installation per individual versus the number of
these jobs that needed to be followed up by a trouble call. I have been
working on this for a couple days now and am about to go nuts. I tried the
IIF expressions, but this did not work. Is there something that I can do to
achieve this
 
Might be able to help if you posted your database table structure with field
names and datatype. Sample data would be a benefit also.
 
Back
Top