[Report] RecordSource=SELECT * FROM training WHERE ((training.horsename Like [horsename] or training.horsename = [horsename] Is Null) and training.date >= [start date] and training.date <= [end date]) ; SortSequence=3, 1 Filter= FilterOn=False OrderBy= OrderByOn=False Caption=TrainingQuery RecordLocks=0 PageHeader=0 PageFooter=0 DateGrouping=1 GrpKeepTogether=1 Width=9300 Picture=(none) PictureType=0 PictureSizeMode=0 PictureAlignment=2 PictureTiling=False PicturePages=0 FastLaserPrinting=True Count=25 LogicalPageWidth=9360 Name=Training Tag= OnOpen= OnClose= OnActivate= OnDeactivate= OnNoData= OnPage= OnError= LeftMargin=1440 TopMargin=1440 RightMargin=1440 BottomMargin=1440 DataOnly=0 ItemSizeWidth=9300 ItemSizeHeight=3600 SameAsDetail=1 ItemsAcross=1 ColumnSpacing=360 RowSpacing=0 ItemLayout=1953 FastPrint=1 Datasheet=1 Orientation=1 PaperSize=1 PaperLength=2794 PaperWidth=2159 [Section Names] Section0=Detail Section1=ReportHeader Section2=ReportFooter Section3=PageHeaderSection Section4=PageFooterSection [Detail Section] Name=Detail ForceNewPage=0 NewRowOrCol=0 KeepTogether=True Visible=True DisplayWhen=0 CanGrow=True CanShrink=False Height=3600 BackColor=16777215 SpecialEffect=0 Tag= OnFormat= OnPrint= OnRetreat= HasContinued=False WillContinue=False [ReportHeader Section] Name=ReportHeader ForceNewPage=0 NewRowOrCol=0 KeepTogether=True Visible=True DisplayWhen=0 CanGrow=False CanShrink=False Height=1380 BackColor=16777215 SpecialEffect=0 Tag= OnFormat= OnPrint= OnRetreat= HasContinued=False WillContinue=False [ReportFooter Section] Name=ReportFooter ForceNewPage=0 NewRowOrCol=0 KeepTogether=True Visible=True DisplayWhen=0 CanGrow=False CanShrink=False Height=780 BackColor=16777215 SpecialEffect=0 Tag= OnFormat= OnPrint= OnRetreat= HasContinued=False WillContinue=False [PageHeaderSection Section] Name=PageHeaderSection Visible=True DisplayWhen=0 Height=480 BackColor=16777215 SpecialEffect=0 Tag= OnFormat= OnPrint= HasContinued=False WillContinue=False [PageFooterSection Section] Name=PageFooterSection Visible=True DisplayWhen=0 Height=780 BackColor=16777215 SpecialEffect=0 Tag= OnFormat= OnPrint= HasContinued=False WillContinue=False [GroupLevel 0] ControlSource=horseName SortOrder=False GroupHeader=False GroupFooter=False GroupOn=0 GroupInterval=1 KeepTogether=0 [GroupLevel 1] ControlSource=date SortOrder=False GroupHeader=False GroupFooter=False GroupOn=0 GroupInterval=1 KeepTogether=0 [Custom] GroupLevels=2 Version=1.0.48 ControlCount=25 [Control-1] Name=Label14 ControlType=100 - Label Caption=Training Report: Visible=True Left=1260 Top=420 Width=3120 Height=510 BackStyle=1 BackColor=16777215 SpecialEffect=0 BorderStyle=0 OldBorderStyle=0 BorderColor=0 BorderWidth=0 BorderLineStyle=0 ForeColor=0 FontName=Times New Roman FontSize=20 FontWeight=900 FontItalic=False FontUnderline=False TextAlign=1 FontBold=True Section=1 - ReportHeader Tag= [Control-2] Name=Text15 ControlType=109 - Text box ControlSource==Now() Format=Long Date DecimalPlaces=255 Visible=True HideDuplicates=False CanGrow=False CanShrink=False RunningSum=0 Left=6780 Top=60 Width=2460 Height=285 BackStyle=1 BackColor=16777215 SpecialEffect=0 BorderStyle=0 OldBorderStyle=0 BorderColor=0 BorderWidth=0 BorderLineStyle=0 ForeColor=0 FontName=Times New Roman FontSize=9 FontWeight=400 FontItalic=False FontUnderline=False TextAlign=1 FontBold=False Section=1 - ReportHeader Tag= [Control-3] Name=Line19 ControlType=102 - Line LineSlant=False Visible=True Left=0 Top=1380 Width=9240 Height=0 SpecialEffect=0 BorderStyle=1 OldBorderStyle=1 BorderColor=0 BorderWidth=1 BorderLineStyle=0 Section=1 - ReportHeader Tag= [Control-4] Name=Label22 ControlType=100 - Label Caption=BarnPro Horse Farm Software Visible=True Left=60 Top=60 Width=3300 Height=300 BackStyle=0 BackColor=16777215 SpecialEffect=0 BorderStyle=0 OldBorderStyle=0 BorderColor=0 BorderWidth=0 BorderLineStyle=0 ForeColor=0 FontName=Times New Roman FontSize=9 FontWeight=400 FontItalic=False FontUnderline=False TextAlign=1 FontBold=False Section=1 - ReportHeader Tag= [Control-5] Name=horseName ControlType=109 - Text box ControlSource=horseName Format= DecimalPlaces=255 Visible=True HideDuplicates=False CanGrow=False CanShrink=False RunningSum=0 Left=4440 Top=360 Width=3240 Height=840 BackStyle=0 BackColor=16777215 SpecialEffect=0 BorderStyle=0 OldBorderStyle=0 BorderColor=0 BorderWidth=0 BorderLineStyle=0 ForeColor=0 FontName=Times New Roman FontSize=24 FontWeight=700 FontItalic=False FontUnderline=False TextAlign=0 FontBold=True Section=1 - ReportHeader Tag= [Control-6] Name=horseName_Label ControlType=100 - Label Caption=Horse Visible=True Left=1200 Top=120 Width=1260 Height=255 BackStyle=0 BackColor=16777215 SpecialEffect=0 BorderStyle=0 OldBorderStyle=0 BorderColor=0 BorderWidth=0 BorderLineStyle=0 ForeColor=0 FontName=Times New Roman FontSize=9 FontWeight=500 FontItalic=False FontUnderline=True TextAlign=1 FontBold=False Section=3 - PageHeader Tag=DetachedLabel [Control-7] Name=date_Label ControlType=100 - Label Caption=Date Visible=True Left=120 Top=120 Width=600 Height=255 BackStyle=0 BackColor=16777215 SpecialEffect=0 BorderStyle=0 OldBorderStyle=0 BorderColor=0 BorderWidth=0 BorderLineStyle=0 ForeColor=0 FontName=Times New Roman FontSize=9 FontWeight=500 FontItalic=False FontUnderline=True TextAlign=1 FontBold=False Section=3 - PageHeader Tag=DetachedLabel [Control-8] Name=riderName_Label ControlType=100 - Label Caption=Rider Visible=True Left=3360 Top=120 Width=1260 Height=255 BackStyle=0 BackColor=16777215 SpecialEffect=0 BorderStyle=0 OldBorderStyle=0 BorderColor=0 BorderWidth=0 BorderLineStyle=0 ForeColor=0 FontName=Times New Roman FontSize=9 FontWeight=500 FontItalic=False FontUnderline=True TextAlign=1 FontBold=False Section=3 - PageHeader Tag=DetachedLabel [Control-9] Name=trainerName_Label ControlType=100 - Label Caption=Trainer Visible=True Left=4920 Top=120 Width=1260 Height=255 BackStyle=0 BackColor=16777215 SpecialEffect=0 BorderStyle=0 OldBorderStyle=0 BorderColor=0 BorderWidth=0 BorderLineStyle=0 ForeColor=0 FontName=Times New Roman FontSize=9 FontWeight=500 FontItalic=False FontUnderline=True TextAlign=1 FontBold=False Section=3 - PageHeader Tag=DetachedLabel [Control-10] Name=Line21 ControlType=102 - Line LineSlant=False Visible=True Left=60 Top=420 Width=9240 Height=0 SpecialEffect=0 BorderStyle=1 OldBorderStyle=1 BorderColor=0 BorderWidth=1 BorderLineStyle=0 Section=3 - PageHeader Tag= [Control-11] Name=date ControlType=109 - Text box ControlSource=date Format= DecimalPlaces=255 Visible=True HideDuplicates=False CanGrow=False CanShrink=False RunningSum=0 Left=120 Top=540 Width=1020 Height=330 BackStyle=0 BackColor=16777215 SpecialEffect=0 BorderStyle=0 OldBorderStyle=0 BorderColor=0 BorderWidth=0 BorderLineStyle=0 ForeColor=0 FontName=Times New Roman FontSize=11 FontWeight=400 FontItalic=False FontUnderline=False TextAlign=1 FontBold=False Section=0 - Detail Tag= [Control-12] Name=riderName ControlType=109 - Text box ControlSource=riderName Format= DecimalPlaces=255 Visible=True HideDuplicates=False CanGrow=False CanShrink=False RunningSum=0 Left=3360 Top=540 Width=1140 Height=330 BackStyle=0 BackColor=16777215 SpecialEffect=0 BorderStyle=0 OldBorderStyle=0 BorderColor=0 BorderWidth=0 BorderLineStyle=0 ForeColor=0 FontName=Times New Roman FontSize=11 FontWeight=400 FontItalic=False FontUnderline=False TextAlign=0 FontBold=False Section=0 - Detail Tag= [Control-13] Name=trainerName ControlType=109 - Text box ControlSource=trainerName Format= DecimalPlaces=255 Visible=True HideDuplicates=False CanGrow=False CanShrink=False RunningSum=0 Left=4920 Top=540 Width=1920 Height=330 BackStyle=0 BackColor=16777215 SpecialEffect=0 BorderStyle=0 OldBorderStyle=0 BorderColor=0 BorderWidth=0 BorderLineStyle=0 ForeColor=0 FontName=Times New Roman FontSize=11 FontWeight=400 FontItalic=False FontUnderline=False TextAlign=0 FontBold=False Section=0 - Detail Tag= [Control-14] Name=riderProgress ControlType=109 - Text box ControlSource=riderProgress Format= DecimalPlaces=255 Visible=True HideDuplicates=False CanGrow=True CanShrink=False RunningSum=0 Left=120 Top=1440 Width=8880 Height=300 BackStyle=0 BackColor=16777215 SpecialEffect=0 BorderStyle=0 OldBorderStyle=0 BorderColor=0 BorderWidth=0 BorderLineStyle=0 ForeColor=0 FontName=Times New Roman FontSize=11 FontWeight=400 FontItalic=False FontUnderline=False TextAlign=0 FontBold=False Section=0 - Detail Tag= [Control-15] Name=horseProgress ControlType=109 - Text box ControlSource=horseProgress Format= DecimalPlaces=255 Visible=True HideDuplicates=False CanGrow=True CanShrink=False RunningSum=0 Left=120 Top=2280 Width=8880 Height=330 BackStyle=0 BackColor=16777215 SpecialEffect=0 BorderStyle=0 OldBorderStyle=0 BorderColor=0 BorderWidth=0 BorderLineStyle=0 ForeColor=0 FontName=Times New Roman FontSize=11 FontWeight=400 FontItalic=False FontUnderline=False TextAlign=0 FontBold=False Section=0 - Detail Tag= [Control-16] Name=lessonFocus ControlType=109 - Text box ControlSource=lessonFocus Format= DecimalPlaces=255 Visible=True HideDuplicates=False CanGrow=True CanShrink=False RunningSum=0 Left=120 Top=3060 Width=8880 Height=330 BackStyle=0 BackColor=16777215 SpecialEffect=0 BorderStyle=0 OldBorderStyle=0 BorderColor=0 BorderWidth=0 BorderLineStyle=0 ForeColor=0 FontName=Times New Roman FontSize=11 FontWeight=400 FontItalic=False FontUnderline=False TextAlign=0 FontBold=False Section=0 - Detail Tag= [Control-17] Name=riderProgress_Label ControlType=100 - Label Caption=Rider's progress: Visible=True Left=120 Top=1080 Width=1800 Height=255 BackStyle=0 BackColor=16777215 SpecialEffect=0 BorderStyle=0 OldBorderStyle=0 BorderColor=0 BorderWidth=0 BorderLineStyle=0 ForeColor=0 FontName=Arial FontSize=9 FontWeight=900 FontItalic=False FontUnderline=False TextAlign=1 FontBold=True Section=0 - Detail Tag=DetachedLabel [Control-18] Name=Horse's progress ControlType=100 - Label Caption=Horse's progress: Visible=True Left=120 Top=1920 Width=1860 Height=255 BackStyle=0 BackColor=16777215 SpecialEffect=0 BorderStyle=0 OldBorderStyle=0 BorderColor=0 BorderWidth=0 BorderLineStyle=0 ForeColor=0 FontName=Arial FontSize=9 FontWeight=900 FontItalic=False FontUnderline=False TextAlign=1 FontBold=True Section=0 - Detail Tag=DetachedLabel [Control-19] Name=lessonFocus_Label ControlType=100 - Label Caption=Next lesson focus: Visible=True Left=120 Top=2760 Width=2100 Height=255 BackStyle=0 BackColor=16777215 SpecialEffect=0 BorderStyle=0 OldBorderStyle=0 BorderColor=0 BorderWidth=0 BorderLineStyle=0 ForeColor=0 FontName=Arial FontSize=9 FontWeight=900 FontItalic=False FontUnderline=False TextAlign=1 FontBold=True Section=0 - Detail Tag=DetachedLabel [Control-20] Name=nextDate ControlType=109 - Text box ControlSource=nextDate Format= DecimalPlaces=255 Visible=True HideDuplicates=False CanGrow=False CanShrink=False RunningSum=0 Left=4200 Top=2760 Width=1200 Height=300 BackStyle=0 BackColor=16777215 SpecialEffect=0 BorderStyle=0 OldBorderStyle=0 BorderColor=0 BorderWidth=0 BorderLineStyle=0 ForeColor=0 FontName=Times New Roman FontSize=11 FontWeight=400 FontItalic=False FontUnderline=False TextAlign=0 FontBold=False Section=0 - Detail Tag= [Control-21] Name=Label23 ControlType=100 - Label Caption=Next Appt: Visible=True Left=3060 Top=2760 Width=1065 Height=285 BackStyle=0 BackColor=16777215 SpecialEffect=0 BorderStyle=0 OldBorderStyle=0 BorderColor=0 BorderWidth=0 BorderLineStyle=0 ForeColor=0 FontName=Arial FontSize=9 FontWeight=700 FontItalic=False FontUnderline=False TextAlign=0 FontBold=True Section=0 - Detail Tag= [Control-22] Name=apptTime ControlType=109 - Text box ControlSource=apptTime Format= DecimalPlaces=255 Visible=True HideDuplicates=False CanGrow=False CanShrink=False RunningSum=0 Left=6240 Top=2760 Width=1920 Height=300 BackStyle=0 BackColor=16777215 SpecialEffect=0 BorderStyle=0 OldBorderStyle=0 BorderColor=0 BorderWidth=0 BorderLineStyle=0 ForeColor=0 FontName=Times New Roman FontSize=11 FontWeight=400 FontItalic=False FontUnderline=False TextAlign=0 FontBold=False Section=0 - Detail Tag= [Control-23] Name=Label24 ControlType=100 - Label Caption=|vbSpace| Time: Visible=True Left=5460 Top=2760 Width=660 Height=285 BackStyle=0 BackColor=16777215 SpecialEffect=0 BorderStyle=0 OldBorderStyle=0 BorderColor=0 BorderWidth=0 BorderLineStyle=0 ForeColor=0 FontName=Arial FontSize=9 FontWeight=700 FontItalic=False FontUnderline=False TextAlign=0 FontBold=True Section=0 - Detail Tag= [Control-24] Name=Line18 ControlType=102 - Line LineSlant=False Visible=True Left=60 Top=240 Width=9240 Height=0 SpecialEffect=0 BorderStyle=1 OldBorderStyle=1 BorderColor=12632256 BorderWidth=1 BorderLineStyle=0 Section=4 - PageFooter Tag= [Control-25] Name=Text16 ControlType=109 - Text box ControlSource=="Page " & [Page] & " of " & [Pages] Format= DecimalPlaces=255 Visible=True HideDuplicates=False CanGrow=False CanShrink=False RunningSum=0 Left=5460 Top=240 Width=3420 Height=285 BackStyle=1 BackColor=16777215 SpecialEffect=0 BorderStyle=0 OldBorderStyle=0 BorderColor=0 BorderWidth=0 BorderLineStyle=0 ForeColor=0 FontName=Arial FontSize=9 FontWeight=700 FontItalic=False FontUnderline=False TextAlign=3 FontBold=True Section=4 - PageFooter Tag= [Parameters] NParms=3 ParameterName1=[start date] ParameterType1=DateTime ParameterName2=[end date] ParameterType2=DateTime ParameterName3=[horsename] ParameterType3=Text