Re: Not sure I can do this.

Hi John,

I assumed you could see the whole thread. Each check box is a business
unit. Each record can have more than one business unit associated to it. I
filter for the value of one business unit. But I think the problem is that
some of the others are true also.

Here is the SQ. Balboa begins the check boxes.

SELECT qry_postmortems_Date.Vendor, qry_postmortems_Date.OutageDate,
qry_postmortems_Date.Location, qry_postmortems_Date.IssueCause,
qry_postmortems_Date.Issue_Platform, qry_postmortems_Date.BriefDescription,
qry_postmortems_Date.Balboa, qry_postmortems_Date.CapitalMkt_SecondaryMkt,
qry_postmortems_Date.CIS, qry_postmortems_Date.CLD,
qry_postmortems_Date.CMD_Corp, qry_postmortems_Date.CMD_Remote,
qry_postmortems_Date.FSL_Corp, qry_postmortems_Date.FSL_Remote,
qry_postmortems_Date.HR, qry_postmortems_Date.Landsafe,
qry_postmortems_Date.LoanAdmin, qry_postmortems_Date.ProductionTech,
qry_postmortems_Date.TBank, qry_postmortems_Date.Wholesale_Corp,
qry_postmortems_Date.Wholesale_Remote
FROM qry_postmortems_Date
WHERE (((qry_postmortems_Date.Issue_Platform) Like "*" &
[Forms]![frmPOP_NeilsTrendReports]![txt_NeilsTrendRpt] & "*")) OR
(((qry_postmortems_Date.Issue_Platform) Like "*" &
[Forms]![frmPOP_NeilsTrendReports]![txt_NeilsTrendRpt] & "*") AND
((qry_postmortems_Date.Balboa)=NZ([Forms]![frmPOP_NeilsTrendReports]![chk_Balboa],0))
AND
((qry_postmortems_Date.CapitalMkt_SecondaryMkt)=NZ([Forms]![frmPOP_NeilsTrendReports]![chk_CSC],0))
AND
((qry_postmortems_Date.CIS)=NZ([Forms]![frmPOP_NeilsTrendReports]![chk_CIS],0))
AND
((qry_postmortems_Date.CLD)=NZ([Forms]![frmPOP_NeilsTrendReports]![chk_CLD],0))
AND
((qry_postmortems_Date.CMD_Corp)=NZ([Forms]![frmPOP_NeilsTrendReports]![chk_CMD_Corp],0))
AND
((qry_postmortems_Date.CMD_Remote)=NZ([Forms]![frmPOP_NeilsTrendReports]![chk_CMD_Remote],0))
AND
((qry_postmortems_Date.FSL_Corp)=NZ([Forms]![frmPOP_NeilsTrendReports]![chk_FSL_Corp],0))
AND
((qry_postmortems_Date.FSL_Remote)=NZ([Forms]![frmPOP_NeilsTrendReports]![chk_FSL_Remote],0))
AND
((qry_postmortems_Date.HR)=NZ([Forms]![frmPOP_NeilsTrendReports]![chk_HR],0))
AND
((qry_postmortems_Date.Landsafe)=NZ([Forms]![frmPOP_NeilsTrendReports]![chk_Landsafe],0))
AND
((qry_postmortems_Date.LoanAdmin)=NZ([Forms]![frmPOP_NeilsTrendReports]![chk_LoanAdmin],0))
AND
((qry_postmortems_Date.ProductionTech)=NZ([Forms]![frmPOP_NeilsTrendReports]![chk_PT],0))
AND
((qry_postmortems_Date.TBank)=NZ([Forms]![frmPOP_NeilsTrendReports]![chk_TBank],0))
AND
((qry_postmortems_Date.Wholesale_Corp)=NZ([Forms]![frmPOP_NeilsTrendReports]![chk_Wholesale_Corp],0))
AND
((qry_postmortems_Date.Wholesale_Remote)=NZ([Forms]![frmPOP_NeilsTrendReports]![chk_Wholesale_Remote],0)))
ORDER BY qry_postmortems_Date.OutageDate;


Thanks,


"John Vinson" wrote:

> On Tue, 23 Aug 2005 06:58:10 -0700, "Karen53"
> <Karen53@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> >Hi John,
> >
> >That is why I used check boxes but am having trouble filtering by them. See
> >my earlier postings. I take it then, there isn't a way to filter these
> >check boxes?
>
> A checkbox IS NOT DATA.
>
> A checkbox is a display tool, just as a Combo Box or a Textbox are
> display tools.
>
> I presume - you haven't explicitly said - that you have a
> (non-normalized, in need of redesign per my suggestions :-{( ) table
> with Yes/No fields ("checkboxes" in table data*** view) and that you
> want to select records based on the values in these checkboxes. Of
> course it is possible to query on the value of these yes/no fields!
> Access wouldn't be much use if you couldn't use it for searching!
>
> But please... give us a break.
>
> What is the structure of your table?
> What is the SQL view of the query which is returning too few records?
> Please open it in SQL view and copy and paste the text to a message
> here.
>
> You might have posted some of this information earlier, but I haven't
> taken the time to fire up Google Groups and search for it - maybe a
> fresh start would be better anyway!
>
> John W. Vinson[MVP]
>
.