Report Query

  • Thread starter Thread starter Louise
  • Start date Start date
L

Louise

In my query I have a field titled "TurnaroundDays"
and "DateReceived". There are different values for
turnaroundDays for different Case Types. The normal
turnaround time is 2, however for
"CaseType10" and "CaseType20" I need the "TurnaroundDays"
to = 4 for these specific "DateReceived" 01/08/04 and
01/09/04 and 01/15/2004 and 01/16/2004.

I want to use and expression in my "TurnAroundDays" query
criteria. I've tried

If [DateReceived]= 01/08/2004 and 01/09/2004 and
01/15/2004 and 01/16/2003 for [tblCases Casetype
CaseTypeID=10 and CaseTypeID=20]then[TurnaroundDays] = 4

I'm new to access and there is something wroing with the
format of my code. Any help you can give me is
appriciated or am I going about this the wrong way?

Thank you
..
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You can use the IIf() function. E.g.:

SELECT ...
IIf(DateReceived In (#1/8/2004#, #1/9/2004#, #1/15/2004#, #1/16/2004#)
And CaseTypeID In (10, 20), 4) As TurnAroundDays
FROM ...

HTH,

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQBgp7IechKqOuFEgEQIrOwCdHvkkXHn7Ogi2O7HE3wd6LBYgHtMAoLxC
oQFsi3tCvbeyWBFAsFydw+5m
=VdPy
-----END PGP SIGNATURE-----
 
Back
Top