Hi all,
tried for 3 days but just can't crack this one.
i have a table with column headings DATE, EXPENSE,AMOUNT with a drop down menu on the expense column listing fuel,insurance,maintenance etc. then i manually enter the amount.
Away from the table i need to total items purchased
Between certain dates AND Type of expense.
eg Fall between Jan1st to March31st AND says "fuel" in the expenses column.= ????
Fall between Jan1st to March31st AND says "insurance" in the expenses column= ????
Fall between Jan1st to March31st AND says "maintenance" in the expenses column=????
I hope this makes sense
Thank you in anticipation
thumper64 (phil) <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->
tried for 3 days but just can't crack this one.
i have a table with column headings DATE, EXPENSE,AMOUNT with a drop down menu on the expense column listing fuel,insurance,maintenance etc. then i manually enter the amount.
Away from the table i need to total items purchased
Between certain dates AND Type of expense.
eg Fall between Jan1st to March31st AND says "fuel" in the expenses column.= ????
Fall between Jan1st to March31st AND says "insurance" in the expenses column= ????
Fall between Jan1st to March31st AND says "maintenance" in the expenses column=????
I hope this makes sense
Thank you in anticipation
thumper64 (phil) <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->