Hi,
I have a report using the following SQL:
SELECT Month([doi]) AS [Month], Year([doi]) AS [Year], [Location
Code].Location, Client.TypeClient, IIf([IncidentData.Restraint]
=1,1,0) AS Rest, IIf([incidentData.PoliceType]="1",1,0) AS PolN, IIf
([incidentData.PoliceType]="2",1,0) AS PolE, IIf
([IncidentData.IncidentType]=1,1,0) AS AwolES, IIf
([Incidentdata.IncidentType]=17,1,0) AS AwolNES, IIf
([IncidentData.IncidentType]=2,1,0) AS Abuse, IIf
([IncidentData.IncidentType]=3,1,0) AS AssltStaff, IIf
([IncidentData.IncidentType]=4,1,0) AS AssltClient, IIf
([IncidentData.IncidentType]=5,1,0) AS SexMis, IIf
([IncidentData.IncidentType]=6,1,0) AS Alcohol, IIf
([IncidentData.IncidentType]=7,1,0) AS Weapon, IIf
([IncidentData.IncidentType]=8,1,0) AS IllPhy, IIf
([IncidentData.IncidentType]=9,1,0) AS Injury, IIf
([IncidentData.IncidentType]=10,1,0) AS SuicideAtt, IIf
([IncidentData.IncidentType]=11,1,0) AS Suicide, IIf
([IncidentData.IncidentType]=12,1,0) AS Death, IIf
([IncidentData.IncidentType]=13,1,0) AS IccDose, IIf
([IncidentData.IncidentType]=14,1,0) AS IccMed, IIf
([IncidentData.IncidentType]=15,1,0) AS WrongTime, IIf
([IncidentData.IncidentType]=16,1,0) AS MissingMed, IIf
([IncidentData.IncidentType]=18,1,0) AS IllMed, IIf
([IncidentData.IncidentType]=19,1,0) AS SelfInj, IIf
([IncidentData.IncidentType]=20,1,0) AS Other
FROM ([Location Code] INNER JOIN (Client INNER JOIN IncidentData ON
Client.ClientID = IncidentData.clientid) ON [Location Code].[Location
Code] = Client.CurrentLocation) INNER JOIN IncidentType ON
IncidentData.IncidentType = IncidentType.IncidentType
WHERE (((Month([doi]))=[forms]![ReportsMenudivdir]![cbomonth]) AND
((Year([doi]))=[forms]![ReportsMenudivdir]![cboyear]) AND (([Location
Code].Location)=[forms]![ReportsMenudivdir]![cbolocation]));
My WHERE parts doesn't seem to work.
If I run the query, I do not get prompted for Location , month or
year it just runs?
Am I not supposed to be propted even when I run the query?
Is it different for Running reports and forms?
Thanks In Advance
Joe
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
