Query

[Tasha]

I have a table which is based on a defect report for wagons. There are
various text boxes to fill in, and also tick boxes. I have produced queries
to which require you to enter a reg, the date etc.
When i run the query - bringing up my report - it shows the fields that are
empty. For example, there are up to 20 defects, thew vehicle may only have
one defect; how do i hide the empty check boxes?

Thanks in advance!!

 

[KARL DEWEY]

how do i hide the empty check boxes?
Best way is not to use check boxes in this fashion but use a related table
to record defects and a table listing the kinds of defects and possibly
another listing locations to select from.

Such as --
Defect Location
Weld Tounge to handle
Paint Under bed
Bent Axel
Missing Wheel cotter pin

 

[Jerry Whittle]

Your basic table design is wrong. You shouldn't have a tick box field for
each defect. What happens when someone decides to add another defect? You
will need to add a field to the table, then revise all your queries, forms,
and reports that use the table.

Instead you should have tables that looks something like:

Wagons
RegID and all the stuff about the wagon.

Reports
ReportID Date RegId and other info about the report

ReportDefects
ReportID DefectID
1 1
1 3


Defects
DefectID Defect
1 Flat Tire
2 Slow Mule
3 Lost Station

Then you would join the above tables as necessary in a query. You might even
need a crosstab query to see the data something like you have now.