Criteria based on Checkbox

[steve1111]

I have table.[reconciled] tat allows for a check box. i want to enter in the criteria filed in query design that i only want to see the unchecked or false entries. i have tried writing the criteria multiple ways and i cannot get it to filter out on my sub form query. Any ideas. i will past the SQL code but i am not very experience with writing in that.

SELECT FuelmanImport_tbl.Reconciled, [Driver PIN].Division, [Driver PIN].[Transportation Supervisor], FuelmanImport_tbl.[Transaction Date], FuelmanImport_tbl.[Card Number], [Driver PIN].Driver, FuelmanImport_tbl.[Cardholder Name], FuelmanImport_tbl.[Prompted ID], FuelmanImport_tbl.[MCC Description], FuelmanImport_tbl.[Merchant Name], FuelmanImport_tbl.[Merchant Address], FuelmanImport_tbl.[Merchant City], FuelmanImport_tbl.[Posted Amount], Expense_tbl.Date, Expense_tbl.Amount, [Driver PIN].[Prompted ID], FuelmanImport_tbl.ID
FROM (FuelmanImport_tbl LEFT JOIN Expense_tbl ON (FuelmanImport_tbl.[Transaction Date] = Expense_tbl.Date) AND (FuelmanImport_tbl.[Posted Amount] = Expense_tbl.Amount)) LEFT JOIN [Driver PIN] ON FuelmanImport_tbl.[Prompted ID] = [Driver PIN].[Prompted ID]
GROUP BY FuelmanImport_tbl.Reconciled, [Driver PIN].Division, [Driver PIN].[Transportation Supervisor], FuelmanImport_tbl.[Transaction Date], FuelmanImport_tbl.[Card Number], [Driver PIN].Driver, FuelmanImport_tbl.[Cardholder Name], FuelmanImport_tbl.[Prompted ID], FuelmanImport_tbl.[MCC Description], FuelmanImport_tbl.[Merchant Name], FuelmanImport_tbl.[Merchant Address], FuelmanImport_tbl.[Merchant City], FuelmanImport_tbl.[Posted Amount], Expense_tbl.Date, Expense_tbl.Amount, [Driver PIN].[Prompted ID], FuelmanImport_tbl.ID, [Forms]![Receipt Reconciliation Report]![Division Combo], [Forms]![Receipt Reconciliation Report]![Trans Sup Combo], [Forms]![Receipt Reconciliation Report]![To Date], [Forms]![Receipt Reconciliation Report]![Driver Combo], [Forms]![Receipt Reconciliation Report]![PIN Combo]
HAVING ((([Driver PIN].Division)=[Forms]![Receipt Reconciliation Report]![Division Combo]) AND (([Driver PIN].[Transportation Supervisor])=[Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) AND ((FuelmanImport_tbl.[Transaction Date]) Between [Forms]![Receipt Reconciliation Report]![From Date] And [Forms]![Receipt Reconciliation Report]![To Date]) AND (([Driver PIN].Driver)=[Forms]![Receipt Reconciliation Report]![Driver Combo]) AND ((FuelmanImport_tbl.[Prompted ID])=[Forms]![Receipt Reconciliation Report]![PIN Combo]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([FuelmanImport_tbl]![Reconciled])=False And ([FuelmanImport_tbl]![Reconciled])=False And ([FuelmanImport_tbl]![Reconciled])=0 And ([FuelmanImport_tbl]![Reconciled])=0)) OR ((([Driver PIN].[Transportation Supervisor])=[Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) AND ((FuelmanImport_tbl.[Transaction Date]) Between [Forms]![Receipt Reconciliation Report]![From Date] And [Forms]![Receipt Reconciliation Report]![To Date]) AND (([Driver PIN].Driver)=[Forms]![Receipt Reconciliation Report]![Driver Combo]) AND ((FuelmanImport_tbl.[Prompted ID])=[Forms]![Receipt Reconciliation Report]![PIN Combo]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Division Combo]) Is Null)) OR ((([Driver PIN].Division)=[Forms]![Receipt Reconciliation Report]![Division Combo]) AND ((FuelmanImport_tbl.[Transaction Date]) Between [Forms]![Receipt Reconciliation Report]![From Date] And [Forms]![Receipt Reconciliation Report]![To Date]) AND (([Driver PIN].Driver)=[Forms]![Receipt Reconciliation Report]![Driver Combo]) AND ((FuelmanImport_tbl.[Prompted ID])=[Forms]![Receipt Reconciliation Report]![PIN Combo]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) Is Null)) OR (((FuelmanImport_tbl.[Transaction Date]) Between [Forms]![Receipt Reconciliation Report]![From Date] And [Forms]![Receipt Reconciliation Report]![To Date]) AND (([Driver PIN].Driver)=[Forms]![Receipt Reconciliation Report]![Driver Combo]) AND ((FuelmanImport_tbl.[Prompted ID])=[Forms]![Receipt Reconciliation Report]![PIN Combo]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Division Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) Is Null)) OR ((([Driver PIN].Division)=[Forms]![Receipt Reconciliation Report]![Division Combo]) AND (([Driver PIN].[Transportation Supervisor])=[Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) AND ((FuelmanImport_tbl.[Transaction Date])=[Forms]![Receipt Reconciliation Report]![From Date]) AND (([Driver PIN].Driver)=[Forms]![Receipt Reconciliation Report]![Driver Combo]) AND ((FuelmanImport_tbl.[Prompted ID])=[Forms]![Receipt Reconciliation Report]![PIN Combo]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![To Date]) Is Null)) OR ((([Driver PIN].[Transportation Supervisor])=[Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) AND ((FuelmanImport_tbl.[Transaction Date])=[Forms]![Receipt Reconciliation Report]![From Date]) AND (([Driver PIN].Driver)=[Forms]![Receipt Reconciliation Report]![Driver Combo]) AND ((FuelmanImport_tbl.[Prompted ID])=[Forms]![Receipt Reconciliation Report]![PIN Combo]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Division Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![To Date]) Is Null)) OR ((([Driver PIN].Division)=[Forms]![Receipt Reconciliation Report]![Division Combo]) AND ((FuelmanImport_tbl.[Transaction Date])=[Forms]![Receipt Reconciliation Report]![From Date]) AND (([Driver PIN].Driver)=[Forms]![Receipt Reconciliation Report]![Driver Combo]) AND ((FuelmanImport_tbl.[Prompted ID])=[Forms]![Receipt Reconciliation Report]![PIN Combo]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![To Date]) Is Null)) OR (((FuelmanImport_tbl.[Transaction Date])=[Forms]![Receipt Reconciliation Report]![From Date]) AND (([Driver PIN].Driver)=[Forms]![Receipt Reconciliation Report]![Driver Combo]) AND ((FuelmanImport_tbl.[Prompted ID])=[Forms]![Receipt Reconciliation Report]![PIN Combo]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Division Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![To Date]) Is Null)) OR ((([Driver PIN].Division)=[Forms]![Receipt Reconciliation Report]![Division Combo]) AND (([Driver PIN].[Transportation Supervisor])=[Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) AND ((FuelmanImport_tbl.[Transaction Date]) Between [Forms]![Receipt Reconciliation Report]![From Date] And [Forms]![Receipt Reconciliation Report]![To Date]) AND ((FuelmanImport_tbl.[Prompted ID])=[Forms]![Receipt Reconciliation Report]![PIN Combo]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Driver Combo]) Is Null)) OR ((([Driver PIN].[Transportation Supervisor])=[Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) AND ((FuelmanImport_tbl.[Transaction Date]) Between [Forms]![Receipt Reconciliation Report]![From Date] And [Forms]![Receipt Reconciliation Report]![To Date]) AND ((FuelmanImport_tbl.[Prompted ID])=[Forms]![Receipt Reconciliation Report]![PIN Combo]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Division Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Driver Combo]) Is Null)) OR ((([Driver PIN].Division)=[Forms]![Receipt Reconciliation Report]![Division Combo]) AND ((FuelmanImport_tbl.[Transaction Date]) Between [Forms]![Receipt Reconciliation Report]![From Date] And [Forms]![Receipt Reconciliation Report]![To Date]) AND ((FuelmanImport_tbl.[Prompted ID])=[Forms]![Receipt Reconciliation Report]![PIN Combo]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Driver Combo]) Is Null)) OR (((FuelmanImport_tbl.[Transaction Date]) Between [Forms]![Receipt Reconciliation Report]![From Date] And [Forms]![Receipt Reconciliation Report]![To Date]) AND ((FuelmanImport_tbl.[Prompted ID])=[Forms]![Receipt Reconciliation Report]![PIN Combo]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Division Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Driver Combo]) Is Null)) OR ((([Driver PIN].Division)=[Forms]![Receipt Reconciliation Report]![Division Combo]) AND (([Driver PIN].[Transportation Supervisor])=[Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) AND ((FuelmanImport_tbl.[Transaction Date])=[Forms]![Receipt Reconciliation Report]![From Date]) AND ((FuelmanImport_tbl.[Prompted ID])=[Forms]![Receipt Reconciliation Report]![PIN Combo]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![To Date]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Driver Combo]) Is Null)) OR ((([Driver PIN].[Transportation Supervisor])=[Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) AND ((FuelmanImport_tbl.[Transaction Date])=[Forms]![Receipt Reconciliation Report]![From Date]) AND ((FuelmanImport_tbl.[Prompted ID])=[Forms]![Receipt Reconciliation Report]![PIN Combo]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Division Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![To Date]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Driver Combo]) Is Null)) OR ((([Driver PIN].Division)=[Forms]![Receipt Reconciliation Report]![Division Combo]) AND ((FuelmanImport_tbl.[Transaction Date])=[Forms]![Receipt Reconciliation Report]![From Date]) AND ((FuelmanImport_tbl.[Prompted ID])=[Forms]![Receipt Reconciliation Report]![PIN Combo]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![To Date]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Driver Combo]) Is Null)) OR (((FuelmanImport_tbl.[Transaction Date])=[Forms]![Receipt Reconciliation Report]![From Date]) AND ((FuelmanImport_tbl.[Prompted ID])=[Forms]![Receipt Reconciliation Report]![PIN Combo]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Division Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![To Date]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Driver Combo]) Is Null)) OR ((([Driver PIN].Division)=[Forms]![Receipt Reconciliation Report]![Division Combo]) AND (([Driver PIN].[Transportation Supervisor])=[Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) AND ((FuelmanImport_tbl.[Transaction Date]) Between [Forms]![Receipt Reconciliation Report]![From Date] And [Forms]![Receipt Reconciliation Report]![To Date]) AND (([Driver PIN].Driver)=[Forms]![Receipt Reconciliation Report]![Driver Combo]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![PIN Combo]) Is Null)) OR ((([Driver PIN].[Transportation Supervisor])=[Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) AND ((FuelmanImport_tbl.[Transaction Date]) Between [Forms]![Receipt Reconciliation Report]![From Date] And [Forms]![Receipt Reconciliation Report]![To Date]) AND (([Driver PIN].Driver)=[Forms]![Receipt Reconciliation Report]![Driver Combo]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Division Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![PIN Combo]) Is Null)) OR ((([Driver PIN].Division)=[Forms]![Receipt Reconciliation Report]![Division Combo]) AND ((FuelmanImport_tbl.[Transaction Date]) Between [Forms]![Receipt Reconciliation Report]![From Date] And [Forms]![Receipt Reconciliation Report]![To Date]) AND (([Driver PIN].Driver)=[Forms]![Receipt Reconciliation Report]![Driver Combo]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![PIN Combo]) Is Null)) OR (((FuelmanImport_tbl.[Transaction Date]) Between [Forms]![Receipt Reconciliation Report]![From Date] And [Forms]![Receipt Reconciliation Report]![To Date]) AND (([Driver PIN].Driver)=[Forms]![Receipt Reconciliation Report]![Driver Combo]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Division Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![PIN Combo]) Is Null)) OR ((([Driver PIN].Division)=[Forms]![Receipt Reconciliation Report]![Division Combo]) AND (([Driver PIN].[Transportation Supervisor])=[Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) AND ((FuelmanImport_tbl.[Transaction Date])=[Forms]![Receipt Reconciliation Report]![From Date]) AND (([Driver PIN].Driver)=[Forms]![Receipt Reconciliation Report]![Driver Combo]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![To Date]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![PIN Combo]) Is Null)) OR ((([Driver PIN].[Transportation Supervisor])=[Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) AND ((FuelmanImport_tbl.[Transaction Date])=[Forms]![Receipt Reconciliation Report]![From Date]) AND (([Driver PIN].Driver)=[Forms]![Receipt Reconciliation Report]![Driver Combo]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Division Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![To Date]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![PIN Combo]) Is Null)) OR ((([Driver PIN].Division)=[Forms]![Receipt Reconciliation Report]![Division Combo]) AND ((FuelmanImport_tbl.[Transaction Date])=[Forms]![Receipt Reconciliation Report]![From Date]) AND (([Driver PIN].Driver)=[Forms]![Receipt Reconciliation Report]![Driver Combo]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![To Date]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![PIN Combo]) Is Null)) OR (((FuelmanImport_tbl.[Transaction Date])=[Forms]![Receipt Reconciliation Report]![From Date]) AND (([Driver PIN].Driver)=[Forms]![Receipt Reconciliation Report]![Driver Combo]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Division Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![To Date]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![PIN Combo]) Is Null)) OR ((([Driver PIN].Division)=[Forms]![Receipt Reconciliation Report]![Division Combo]) AND (([Driver PIN].[Transportation Supervisor])=[Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) AND ((FuelmanImport_tbl.[Transaction Date]) Between [Forms]![Receipt Reconciliation Report]![From Date] And [Forms]![Receipt Reconciliation Report]![To Date]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Driver Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![PIN Combo]) Is Null)) OR ((([Driver PIN].[Transportation Supervisor])=[Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) AND ((FuelmanImport_tbl.[Transaction Date]) Between [Forms]![Receipt Reconciliation Report]![From Date] And [Forms]![Receipt Reconciliation Report]![To Date]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Division Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Driver Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![PIN Combo]) Is Null)) OR ((([Driver PIN].Division)=[Forms]![Receipt Reconciliation Report]![Division Combo]) AND ((FuelmanImport_tbl.[Transaction Date]) Between [Forms]![Receipt Reconciliation Report]![From Date] And [Forms]![Receipt Reconciliation Report]![To Date]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Driver Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![PIN Combo]) Is Null)) OR (((FuelmanImport_tbl.[Transaction Date]) Between [Forms]![Receipt Reconciliation Report]![From Date] And [Forms]![Receipt Reconciliation Report]![To Date]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Division Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Driver Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![PIN Combo]) Is Null)) OR ((([Driver PIN].Division)=[Forms]![Receipt Reconciliation Report]![Division Combo]) AND (([Driver PIN].[Transportation Supervisor])=[Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) AND ((FuelmanImport_tbl.[Transaction Date])=[Forms]![Receipt Reconciliation Report]![From Date]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![To Date]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Driver Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![PIN Combo]) Is Null)) OR ((([Driver PIN].[Transportation Supervisor])=[Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) AND ((FuelmanImport_tbl.[Transaction Date])=[Forms]![Receipt Reconciliation Report]![From Date]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Division Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![To Date]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Driver Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![PIN Combo]) Is Null)) OR ((([Driver PIN].Division)=[Forms]![Receipt Reconciliation Report]![Division Combo]) AND ((FuelmanImport_tbl.[Transaction Date])=[Forms]![Receipt Reconciliation Report]![From Date]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![To Date]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Driver Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![PIN Combo]) Is Null)) OR (((FuelmanImport_tbl.[Transaction Date])=[Forms]![Receipt Reconciliation Report]![From Date]) AND ((Expense_tbl.Date) Is Null) AND ((Expense_tbl.Amount) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Division Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Trans Sup Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![To Date]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![Driver Combo]) Is Null) AND (([Forms]![Receipt Reconciliation Report]![PIN Combo]) Is Null)) OR (((FuelmanImport_tbl.[Prompted ID]) Is Null) AND (([Driver PIN].[Prompted ID]) Is Null));

 

[Mihail]

Have you other SQL, please ?
Only 2 or 3 meters ?

Maybe, if you will explain, in words, what you try to accomplish and will show us the table structure, we'll find, together, a solution.

Cheers.

 

[steve1111]

ok, i have a table with many fields, one being [reconcile] i check that box as true in the table. then i have a reconcile form that i use to filter the date, division etc of a query. however, i only want the query or subform query to show the criteria in the reconcile for AND only the check boxes in the table that are false, or empty. no matter the combination i use in the criteria field my subform query returns both the true and false check box.

 

[Mihail]

Still not understandable.
Upload the DB (Access 2003 or 2007)

 

[steve1111]

I cannot upload this due to company security. However, more simply stated, i want a query to pull only the fields not checkboxed in a table. In the design query criteria field i have tried, =0,=false,=off,=no, then all without the =, no combination seems to work.

 

[Mihail]

You can. I need the DB not the information stored in. Better is to replace the sensitive data with false, but realistic, data. Only in a few records. The rest should be removed.

 

[pr2-eugin]

steve1111, to help us help you..

How to Upload a Stripped DB.

To create a Sample DB (to be uploaded for other users to examine); please follow the steps..

1. Create a backup of the file, before you proceed..
2. Delete all Forms/Queries/Reports that are not in Question (except the ones that are inter-related)
3. Delete auxiliary tables (that are hanging loose with no relationships).
4. If your table has 100,000 records, delete 99,990 records.
5. Replace the sensitive information like Telephone numbers/email with simple UPDATE queries.
6. Perform a 'Compact & Repair' it would have brought the Size down to measly KBs..
7. (If your Post count is less than 10 ZIP the file and) Upload it..

 

[Mihail]

steve1111, to help us help you..

How to Upload a Stripped DB.

To create a Sample DB (to be uploaded for other users to examine); please follow the steps..

1. Create a backup of the file, before you proceed..
2. Delete all Forms/Queries/Reports that are not in Question (except the ones that are inter-related)
3. Delete auxiliary tables (that are hanging loose with no relationships).
4. If your table has 100,000 records, delete 99,990 records.
5. Replace the sensitive information like Telephone numbers/email with simple UPDATE queries.
6. Perform a 'Compact & Repair' it would have brought the Size down to measly KBs..
7. (If your Post count is less than 10 ZIP the file and) Upload it..

Plain English from Paul. I'm wonder where he has learned

 

[spikepl]

I'd guess that your criteria fail to find the desired records because tha value you test for is not set at all. You can test that by using Is Null as criterion to see how many of the expected records turn up.

Otherwise: pay attention to what you post - your first post contains tons of SQL and NOTHING of that is relevant for the question at hand.

But I do notice that you use GROUP BY - is that for any articular reason, since you do not use any aggregate functions? Second, you have no WHERE but only HAVING, which is a huge waste because it discards records AFTER selection. Unless intentional, that comes about from inappropriate use of criteria wehn GROUP BY is in use. You simply need to select the field one more time, untick the display check boxannd list the criterion in the criteria row.

 

[steve1111]

Please run the Receipt reconcile form for 5/1 to 7/1. what i need is for the query in the form to only show the false records, once i reconcile a record i do not want it to show up any more.

thanks

 

[steve1111]

Spikepl, I am a beginner so most of the SQL code was based off what i did in the design view. i have made the adjustments you suggested the query is pulling out the check boxes now, only issue is the small gray parameter box is coming up now with prompting i enter a value for the reconcile field, i dont want that to pop up?

 

[Mihail]

Upload the DB (Access 2003 or 2007)

Have you read this ?

 

[steve1111]

I think i did this correctly...

 

[steve1111]

Spikepl, i was failing to put the reconcile column in the design table twice, i think that i have a workable solution, not the cleanest but it doing the process now. Thanks to everyone for the help!

 

[Mihail]

Not yet. I use 2007 and I'm not able to open your DB.