It queries notes from work done on 35 different machines. One table per machine. There are 2 shifts. One field per shift, for notes.
SELECT Minutesof1V18tbl.Dateof, Minutesof1V18tbl.NotesShift1, Minutesof1V18tbl.NotesShift2, Minutesof200V1FTtbl.Dateof, Minutesof200V1FTtbl.NotesShift1, Minutesof200V1FTtbl.NotesShift2, Minutesof200V4FTtbl.Dateof, Minutesof200V4FTtbl.NotesShift1, Minutesof200V4FTtbl.NotesShift2, Minutesof200V6FT1tbl.Dateof, Minutesof200V6FT1tbl.NotesShift1, Minutesof200V6FT1tbl.NotesShift2, Minutesof200V6FT2tbl.Dateof, Minutesof200V6FT2tbl.NotesShift1, Minutesof200V6FT2tbl.NotesShift2, Minutesof24SFTtbl.Dateof, Minutesof24SFTtbl.NotesShift1, Minutesof24SFTtbl.NotesShift2, Minutesof2A12FTtbl.Dateof, Minutesof2A12FTtbl.NotesShift1, Minutesof2A12FTtbl.NotesShift2, Minutesof2A14FTtbl.Dateof, Minutesof2A14FTtbl.NotesShift1, Minutesof2A14FTtbl.NotesShift2, Minutesof2A3FT1tbl.Dateof, Minutesof2A3FT1tbl.NotesShift1, Minutesof2A3FT1tbl.NotesShift2, Minutesof2A3FT2tbl.Dateof, Minutesof2A3FT2tbl.NotesShift1, Minutesof2A3FT2tbl.NotesShift2, MinutesofLEWIS2CVtbl.Dateof, MinutesofLEWIS2CVtbl.NotesShift1, MinutesofLEWIS2CVtbl.NotesShift2, MinutesofROLLTORSION1tbl.Dateof, MinutesofROLLTORSION1tbl.NotesShift1, MinutesofROLLTORSION1tbl.NotesShift2, MinutesofRollTorsion2tbl.Dateof, MinutesofRollTorsion2tbl.NotesShift1, MinutesofRollTorsion2tbl.NotesShift2, MinutesofRollTorsion3tbl.Dateof, MinutesofRollTorsion3tbl.NotesShift1, MinutesofRollTorsion3tbl.NotesShift2, Minutesof2A4VFtbl.Dateof, Minutesof2A4VFtbl.NotesShift1, Minutesof2A4VFtbl.NotesShift2, MinutesofSIAVStbl.Dateof, MinutesofSIAVStbl.NotesShift1, MinutesofSIAVStbl.NotesShift2, MinutesofTAK1tbl.Dateof, MinutesofTAK1tbl.NotesShift1, MinutesofTAK1tbl.NotesShift2, MinutesofTAK2tbl.Dateof, MinutesofTAK2tbl.NotesShift1, MinutesofTAK2tbl.NotesShift2, MinutesofTAK3tbl.Dateof, MinutesofTAK3tbl.NotesShift1, MinutesofTAK3tbl.NotesShift2, Minutesof5Atbl.Dateof, Minutesof5Atbl.NotesShift1, Minutesof5Atbl.NotesShift2, Minutesof200V12FTtbl.Dateof, Minutesof200V12FTtbl.NotesShift1, Minutesof200V12FTtbl.NotesShift2, Minutesof300Vtbl.Dateof, Minutesof300Vtbl.NotesShift1, Minutesof300Vtbl.NotesShift2, Minutesof400EVtbl.Dateof, Minutesof400EVtbl.NotesShift1, Minutesof400EVtbl.NotesShift2, Minutesof500Vtbl.Dateof, Minutesof500Vtbl.NotesShift1, Minutesof500Vtbl.NotesShift2, Minutesof400vTBL.Dateof, Minutesof400vTBL.NotesShift1, Minutesof400vTBL.NotesShift2, MinutesofTAK4TBL.Dateof, MinutesofTAK4TBL.NotesShift1, MinutesofTAK4TBL.NotesShift2, MinutesofCG1TBL.Dateof, MinutesofCG1TBL.NotesShift1, MinutesofCG1TBL.NotesShift2, MinutesofCG2TBL.Dateof, MinutesofCG2TBL.NotesShift1, MinutesofCG2TBL.NotesShift2, MinutesofCG3TBL.Dateof, MinutesofCG3TBL.NotesShift1, MinutesofCG3TBL.NotesShift2, MinutesofCG4TBL.Dateof, MinutesofCG4TBL.NotesShift1, MinutesofCG4TBL.NotesShift2, MinutesofCG5TBL.Dateof, MinutesofCG5TBL.NotesShift1, MinutesofCG5TBL.NotesShift2, MinutesofCG6TBL.Dateof, MinutesofCG6TBL.NotesShift1, MinutesofCG6TBL.NotesShift2, Minutesof200V16FTtbl.Dateof, Minutesof200V16FTtbl.NotesShift1, Minutesof200V16FTtbl.NotesShift2
FROM Minutesof1V18tbl, Minutesof200V1FTtbl, Minutesof200V4FTtbl, Minutesof200V6FT1tbl, Minutesof200V6FT2tbl, Minutesof24SFTtbl, Minutesof2A12FTtbl, Minutesof2A14FTtbl, Minutesof2A3FT1tbl, Minutesof2A3FT2tbl, MinutesofLEWIS2CVtbl, MinutesofROLLTORSION1tbl, MinutesofRollTorsion2tbl, MinutesofRollTorsion3tbl, Minutesof2A4VFtbl, MinutesofSIAVStbl, MinutesofTAK1tbl, MinutesofTAK2tbl, MinutesofTAK3tbl, Minutesof5Atbl, Minutesof200V12FTtbl, Minutesof300Vtbl, Minutesof400EVtbl, Minutesof500Vtbl, Minutesof400vTBL, MinutesofCG1TBL, MinutesofCG2TBL, MinutesofCG3TBL, MinutesofCG4TBL, MinutesofCG5TBL, MinutesofCG6TBL, MinutesofTAK4TBL, Minutesof200V16FTtbl
WHERE (((Minutesof1V18tbl.Dateof)=Date()) AND ((Minutesof200V1FTtbl.Dateof)=Date()) AND ((Minutesof200V4FTtbl.Dateof)=Date()) AND ((Minutesof200V6FT1tbl.Dateof)=Date()) AND ((Minutesof200V6FT2tbl.Dateof)=Date()) AND ((Minutesof24SFTtbl.Dateof)=Date()) AND ((Minutesof2A12FTtbl.Dateof)=Date()) AND ((Minutesof2A14FTtbl.Dateof)=Date()) AND ((Minutesof2A3FT1tbl.Dateof)=Date()) AND ((Minutesof2A3FT2tbl.Dateof)=Date()) AND ((MinutesofLEWIS2CVtbl.Dateof)=Date()) AND ((MinutesofROLLTORSION1tbl.Dateof)=Date()) AND ((MinutesofRollTorsion2tbl.Dateof)=Date()) AND ((MinutesofRollTorsion3tbl.Dateof)=Date()) AND ((Minutesof2A4VFtbl.Dateof)=Date()) AND ((MinutesofSIAVStbl.Dateof)=Date()) AND ((MinutesofTAK1tbl.Dateof)=Date()) AND ((MinutesofTAK2tbl.Dateof)=Date()) AND ((MinutesofTAK3tbl.Dateof)=Date()) AND ((Minutesof5Atbl.Dateof)=Date()) AND ((Minutesof200V12FTtbl.Dateof)=Date()) AND ((Minutesof300Vtbl.Dateof)=Date()) AND ((Minutesof400EVtbl.Dateof)=Date()) AND ((Minutesof500Vtbl.Dateof)=Date()) AND ((Minutesof400vTBL.Dateof)=Date()) AND ((MinutesofTAK4TBL.Dateof)=Date()) AND ((MinutesofCG1TBL.Dateof)=Date()) AND ((MinutesofCG2TBL.Dateof)=Date()) AND ((MinutesofCG3TBL.Dateof)=Date()) AND ((MinutesofCG4TBL.Dateof)=Date()) AND ((MinutesofCG5TBL.Dateof)=Date()) AND ((MinutesofCG6TBL.Dateof)=Date()) AND ((Minutesof200V16FTtbl.Dateof)=Date()));