[Report]
RecordSource=SELECT expenses.*, accounts.ownername  FROM expenses, accounts  WHERE ( expenses.accountID = accounts.accountID and  EXPENSES.transaction <> 'Personal' and expenses.transaction <> 'Paymant' and expenses.date >= [start date] and expenses.date <= [end date]) ;
SortSequence=11, 3, 1
Filter=
FilterOn=False
OrderBy=
OrderByOn=False
Caption=expenses
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=28
LogicalPageWidth=9360
Name=expensesbyacct
Tag=
OnOpen=
OnClose=
OnActivate=
OnDeactivate=
OnNoData=
OnPage=
OnError=
LeftMargin=1440
TopMargin=1440
RightMargin=1440
BottomMargin=1440
DataOnly=0
ItemSizeWidth=9300
ItemSizeHeight=525
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
Section5=GroupHeader0
Section6=GroupFooter0
Section7=GroupHeader1
Section8=GroupFooter2

[Detail Section]
Name=Detail
ForceNewPage=0
NewRowOrCol=0
KeepTogether=True
Visible=True
DisplayWhen=0
CanGrow=True
CanShrink=False
Height=525
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=1320
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=540
BackColor=16777215
SpecialEffect=0
Tag=
OnFormat=
OnPrint=
OnRetreat=
HasContinued=False
WillContinue=False

[PageHeaderSection Section]
Name=PageHeaderSection
Visible=True
DisplayWhen=0
Height=420
BackColor=16777215
SpecialEffect=0
Tag=
OnFormat=
OnPrint=
HasContinued=False
WillContinue=False

[PageFooterSection Section]
Name=PageFooterSection
Visible=True
DisplayWhen=0
Height=525
BackColor=16777215
SpecialEffect=0
Tag=
OnFormat=
OnPrint=
HasContinued=False
WillContinue=False

[GroupHeader0 Section]
Name=GroupHeader0
ForceNewPage=0
NewRowOrCol=0
KeepTogether=True
Visible=True
DisplayWhen=0
CanGrow=True
CanShrink=False
RepeatSection=False
Height=420
BackColor=16777215
SpecialEffect=0
Tag=
OnFormat=
OnPrint=
OnRetreat=
HasContinued=False
WillContinue=False
InSelection=False

[GroupFooter0 Section]
Name=GroupFooter0
ForceNewPage=0
NewRowOrCol=0
KeepTogether=True
Visible=True
DisplayWhen=0
CanGrow=False
CanShrink=False
Height=360
BackColor=16777215
SpecialEffect=0
Tag=
OnFormat=
OnPrint=
OnRetreat=
HasContinued=False
WillContinue=False
InSelection=False

[GroupHeader1 Section]
Name=GroupHeader1
ForceNewPage=0
NewRowOrCol=0
KeepTogether=True
Visible=True
DisplayWhen=0
CanGrow=True
CanShrink=False
RepeatSection=False
Height=360
BackColor=16777215
SpecialEffect=0
Tag=
OnFormat=
OnPrint=
OnRetreat=
HasContinued=False
WillContinue=False
InSelection=False

[GroupFooter2 Section]
Name=GroupFooter2
ForceNewPage=0
NewRowOrCol=0
KeepTogether=True
Visible=True
DisplayWhen=0
CanGrow=False
CanShrink=False
Height=360
BackColor=16777215
SpecialEffect=0
Tag=
OnFormat=
OnPrint=
OnRetreat=
HasContinued=False
WillContinue=False
InSelection=False

[GroupLevel 0]
ControlSource=accountID
SortOrder=False
GroupHeader=True
GroupFooter=True
GroupOn=0
GroupInterval=1
KeepTogether=0

[GroupLevel 1]
ControlSource=category
SortOrder=False
GroupHeader=True
GroupFooter=True
GroupOn=0
GroupInterval=1
KeepTogether=0

[GroupLevel 2]
ControlSource=date
SortOrder=False
GroupHeader=False
GroupFooter=False
GroupOn=0
GroupInterval=1
KeepTogether=0

[Custom]
GroupLevels=3
Version=1.0.48
ControlCount=28

[Control-1]
Name=Label14
ControlType=100 - Label
Caption=Expenses Report
Visible=True
Left=1080
Top=360
Width=4800
Height=615
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=6060
Top=600
Width=3120
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=Label25
ControlType=100 - Label
Caption=Does not include expense entries labeled payment or personal!
Visible=True
Left=4560
Top=60
Width=4680
Height=285
BackStyle=0
BackColor=16777215
SpecialEffect=0
BorderStyle=0
OldBorderStyle=0
BorderColor=0
BorderWidth=0
BorderLineStyle=0
ForeColor=0
FontName=Arial
FontSize=8
FontWeight=400
FontItalic=False
FontUnderline=False
TextAlign=1
FontBold=False
Section=1 - ReportHeader
Tag=

[Control-4]
Name=Line31
ControlType=102 - Line
LineSlant=False
Visible=True
Left=60
Top=1260
Width=9180
Height=0
SpecialEffect=0
BorderStyle=1
OldBorderStyle=1
BorderColor=0
BorderWidth=1
BorderLineStyle=0
Section=1 - ReportHeader
Tag=

[Control-5]
Name=Label32
ControlType=100 - Label
Caption=BarnPro Horse Farm Software
Visible=True
Left=60
Top=60
Width=2925
Height=285
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=1 - ReportHeader
Tag=

[Control-6]
Name=date_Label
ControlType=100 - Label
Caption=Date
Visible=True
Left=60
Top=60
Width=540
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=True
TextAlign=1
FontBold=True
Section=3 - PageHeader
Tag=DetachedLabel

[Control-7]
Name=horseName_Label
ControlType=100 - Label
Caption=Horse
Visible=True
Left=5820
Top=60
Width=1020
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=True
TextAlign=1
FontBold=True
Section=3 - PageHeader
Tag=DetachedLabel

[Control-8]
Name=ownername_Label
ControlType=100 - Label
Caption=Account
Visible=True
Left=2280
Top=60
Width=1020
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=True
TextAlign=1
FontBold=True
Section=3 - PageHeader
Tag=DetachedLabel

[Control-9]
Name=purpose_Label
ControlType=100 - Label
Caption=Description
Visible=True
Left=3840
Top=60
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=True
TextAlign=1
FontBold=True
Section=3 - PageHeader
Tag=DetachedLabel

[Control-10]
Name=amount_Label
ControlType=100 - Label
Caption=Amount
Visible=True
Left=7260
Top=60
Width=780
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=True
TextAlign=1
FontBold=True
Section=3 - PageHeader
Tag=DetachedLabel

[Control-11]
Name=amtPaid_Label
ControlType=100 - Label
Caption=Amtpaid
Visible=True
Left=8280
Top=60
Width=960
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=True
TextAlign=1
FontBold=True
Section=3 - PageHeader
Tag=DetachedLabel

[Control-12]
Name=category_Label
ControlType=100 - Label
Caption=Category
Visible=True
Left=900
Top=60
Width=840
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=True
TextAlign=1
FontBold=True
Section=3 - PageHeader
Tag=DetachedLabel

[Control-13]
Name=Line30
ControlType=102 - Line
LineSlant=False
Visible=True
Left=60
Top=360
Width=9180
Height=0
SpecialEffect=0
BorderStyle=1
OldBorderStyle=1
BorderColor=0
BorderWidth=1
BorderLineStyle=0
Section=3 - PageHeader
Tag=

[Control-14]
Name=ownername
ControlType=109 - Text box
ControlSource=ownername
Format=
DecimalPlaces=255
Visible=True
HideDuplicates=False
CanGrow=False
CanShrink=False
RunningSum=0
Left=2280
Top=60
Width=3120
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=10
FontWeight=600
FontItalic=False
FontUnderline=False
TextAlign=0
FontBold=False
Section=5 - GroupLevel-1Header
Tag=

[Control-15]
Name=category
ControlType=109 - Text box
ControlSource=category
Format=
DecimalPlaces=255
Visible=True
HideDuplicates=False
CanGrow=True
CanShrink=False
RunningSum=0
Left=840
Top=0
Width=1260
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=10
FontWeight=400
FontItalic=False
FontUnderline=False
TextAlign=0
FontBold=False
Section=7 - GroupLevel-2Header
Tag=

[Control-16]
Name=date
ControlType=109 - Text box
ControlSource=date
Format=Medium Date
DecimalPlaces=255
Visible=True
HideDuplicates=False
CanGrow=False
CanShrink=False
RunningSum=0
Left=60
Top=60
Width=840
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=8
FontWeight=500
FontItalic=False
FontUnderline=False
TextAlign=1
FontBold=False
Section=0 - Detail
Tag=

[Control-17]
Name=horseName
ControlType=109 - Text box
ControlSource=horseName
Format=
DecimalPlaces=255
Visible=True
HideDuplicates=False
CanGrow=True
CanShrink=False
RunningSum=0
Left=5820
Top=60
Width=1200
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=10
FontWeight=400
FontItalic=False
FontUnderline=False
TextAlign=0
FontBold=False
Section=0 - Detail
Tag=

[Control-18]
Name=amount
ControlType=109 - Text box
ControlSource=amount
Format=Currency
DecimalPlaces=255
Visible=True
HideDuplicates=False
CanGrow=False
CanShrink=False
RunningSum=0
Left=7020
Top=60
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=10
FontWeight=400
FontItalic=False
FontUnderline=False
TextAlign=3
FontBold=False
Section=0 - Detail
Tag=

[Control-19]
Name=amtPaid
ControlType=109 - Text box
ControlSource=amtPaid
Format=Currency
DecimalPlaces=255
Visible=True
HideDuplicates=False
CanGrow=False
CanShrink=False
RunningSum=0
Left=8220
Top=60
Width=840
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=10
FontWeight=400
FontItalic=False
FontUnderline=False
TextAlign=0
FontBold=False
Section=0 - Detail
Tag=

[Control-20]
Name=purpose
ControlType=109 - Text box
ControlSource=purpose
Format=
DecimalPlaces=255
Visible=True
HideDuplicates=False
CanGrow=True
CanShrink=False
RunningSum=0
Left=3840
Top=60
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=10
FontWeight=400
FontItalic=False
FontUnderline=False
TextAlign=0
FontBold=False
Section=0 - Detail
Tag=

[Control-21]
Name=Text33
ControlType=109 - Text box
ControlSource==Sum([amount])
Format=Currency
DecimalPlaces=255
Visible=True
HideDuplicates=False
CanGrow=False
CanShrink=False
RunningSum=0
Left=6840
Top=60
Width=1200
Height=240
BackStyle=0
BackColor=16777215
SpecialEffect=0
BorderStyle=0
OldBorderStyle=0
BorderColor=0
BorderWidth=0
BorderLineStyle=0
ForeColor=0
FontName=Times New Roman
FontSize=10
FontWeight=400
FontItalic=False
FontUnderline=False
TextAlign=0
FontBold=False
Section=6 - GroupLevel-1Footer
Tag=

[Control-22]
Name=Label34
ControlType=100 - Label
Caption=subtotal:
Visible=True
Left=5940
Top=60
Width=900
Height=285
BackStyle=0
BackColor=16777215
SpecialEffect=0
BorderStyle=0
OldBorderStyle=0
BorderColor=0
BorderWidth=0
BorderLineStyle=0
ForeColor=0
FontName=Arial
FontSize=10
FontWeight=700
FontItalic=False
FontUnderline=False
TextAlign=0
FontBold=True
Section=6 - GroupLevel-1Footer
Tag=

[Control-23]
Name=Line35
ControlType=102 - Line
LineSlant=False
Visible=True
Left=6960
Top=60
Width=1200
Height=0
SpecialEffect=0
BorderStyle=1
OldBorderStyle=1
BorderColor=0
BorderWidth=0
BorderLineStyle=0
Section=6 - GroupLevel-1Footer
Tag=

[Control-24]
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=5760
Top=120
Width=3480
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=

[Control-25]
Name=Text22
ControlType=109 - Text box
ControlSource==Sum([amount])
Format=Currency
DecimalPlaces=255
Visible=True
HideDuplicates=False
CanGrow=False
CanShrink=False
RunningSum=0
Left=6360
Top=120
Width=1680
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=10
FontWeight=400
FontItalic=False
FontUnderline=False
TextAlign=3
FontBold=False
Section=2 - ReportFooter
Tag=

[Control-26]
Name=Label23
ControlType=100 - Label
Caption=Total:
Visible=True
Left=5700
Top=120
Width=600
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=2 - ReportFooter
Tag=

[Control-27]
Name=Line25
ControlType=102 - Line
LineSlant=False
Visible=True
Left=6840
Top=120
Width=1200
Height=0
SpecialEffect=0
BorderStyle=1
OldBorderStyle=1
BorderColor=0
BorderWidth=0
BorderLineStyle=0
Section=2 - ReportFooter
Tag=

[Control-28]
Name=Line29
ControlType=102 - Line
LineSlant=False
Visible=True
Left=6720
Top=120
Width=1320
Height=0
SpecialEffect=0
BorderStyle=1
OldBorderStyle=1
BorderColor=0
BorderWidth=0
BorderLineStyle=0
Section=2 - ReportFooter
Tag=

[Parameters]
NParms=2
ParameterName1=[start date]
ParameterType1=DateTime
ParameterName2=[end date]
ParameterType2=DateTime