Hi John I closed the DB, reopened, went to th Report and still got no prompt.
The report opened with #Error in the data fields? I did the same thing with Listbox values, and it works fine? Thanks Joe --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > Joe- > > If the form is open, you won't get prompted. > > John Viescas, author > "Building Microsoft Access Applications" > "Microsoft Office Access 2003 Inside Out" > "Running Microsoft Access 2000" > "SQL Queries for Mere Mortals" > http://www.viescas.com/ > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of eliotchs > Sent: Monday, January 09, 2006 1:23 PM > To: [email protected] > Subject: [ms_access] ?? on dialog on a report ?? > > 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 > 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/
