Would like to pull records on query report using an unbound checkbox

[aaron1riley]

Hi ,



first time poster with no coding experience and basic access skills. Please be kind

Have searched forums and either im staring at answers and not getting it or what i want to do is unworkable.

Using a subform within a Navigation Form I would like to return records on query report using an unbound checkbox. This unbound checkbox when True would then return all false records from 3 other table Fields (Done, Done2,Done3) which are True/false fields (these have been written to by other bound checkboxes on a different sub form).

Hoping someone may have a simple query statement that i can place in the criteria to return the result im after. I have tried several in the Done field and togetor in all 3 with no luck


Thanks

Aaron

[Bob Fitz]

Replace the & with AND

[aaron1riley]

Replace the & with AND

Hi Bob, thanks for helping, i tried this but it shifted it to a new column in query design view, i assume it means its not happy with the statement? It also returned all records wether true or false and im after false for all 3 Done fields (which i forgot to mention)

[Bob Fitz]

Try:
[Forms]![Navigation Form]![NavigationSubform].[Form]![Check64] = True
as the criteria for each of the Done columns

[Welshgasman]

That also looks like your DB is structured incorrectly?

[aaron1riley]

Try:
[Forms]![Navigation Form]![NavigationSubform].[Form]![Check64] = True
as the criteria for each of the Done columns

Thanks for quick response, tried this but its pulling both true and false records up for the done,done2,and done3 field rather than all false or all true

[Bob Fitz]

Thanks for quick response, tried this but its pulling both true and false records up for the done,done2,and done3 field rather than all false or all true

Please post a copy of your db with a few dummy records to illustrate the problem.

[aaron1riley]

possibly , but i dont think things are being conflicted even if it is. I run 2 seperate query reports which work flawlessly but trying the new mentioned feature isnt.

[aaron1riley]

That also looks like your DB is structured incorrectly?

possibly , but i dont think things are being conflicted even if it is. I run 2 seperate query reports which work flawlessly but trying the new mentioned feature isnt.

[aaron1riley]

Please post a copy of your db with a few dummy records to illustrate the problem.

Hi Bob could i possibly email it to you its over 500kb its at 3.4mb

Thanks

[Bob Fitz]

Hi Bob could i possibly email it to you its over 500kb its at 3.4mb

Thanks

Run a Compact and Repair. Then Zip it. Should be small enough then.

[aaron1riley]

Run a Compact and Repair. Then Zip it. Should be small enough then.

MaintenanceLog_fe.zipMaintenanceLog_be.zip

[aaron1riley]

so when i go to the "compile 5 whys form" i would like to select "checkbox64" to return all false "Done","Done2" and "Done3" records.

[Bob Fitz]

Sorry.

Criteria for each column should be just:
[Forms]![Navigation Form]![NavigationSubform].[Form]![Check64]

[aaron1riley]

Tried this a spart of my problem solving and tried it again but it brings up both true and false records togethor. Perhaps something is conflicting the statement.

I would have thought you would need some form of statement to suggest when "check 64" is true then return records which have false data entries in the Done,Done2,Done3 fields. Maybe some sort of IF/Then statement

Something is definetly conflicting it as i just entered false for each column and both true and false came up togethor