Mike E

Ok so here is my formula. Works as a single SELECT statement - how can I get results to be output together Sum of dollars shipped from 2015 and 2016 on the same line. Records are individually created from invoicing. Let ( [ $FiscalYrA = globalFiscalYear; $FiscalYrB = $FiscalYrA - 1; xTab = " "; $SQLResult = ExecuteSQL ( "SELECT \"Customer Number\", \"Name\", SUM (\"Dollars Shipped\" FROM Invoices LEFT JOIN Customer_File ON \"Customer Number\" = \"CustomerNo\" WHERE FiscalYear = ? AND \"Invoice Number\" <> 000000 GROUP BY \"Customer Number\", \"Name\" UNION SELECT \"Customer Number\", \"Name\", SUM (\"Det Dol Shipped\" FROM Invoices LEFT JOIN Customer_File ON \"Customer Number\" = \"CustomerNo\" WHERE FiscalYear = ? AND \"Invoice Number\" <> 000000 GROUP BY \"Customer Number\", \"Name\" ORDER BY \"Customer Number\"" ; xTab; "¶" ; /*Misc Items*/ $FiscalYrA; $FiscalYrB ); $xCount = ValueCount ( $SQLResult ) ] ; $Var ) This all just seems so simple and efficient compared to a sub-summary export to Excel that takes hours.

I have a table that contains items sold over the last 20 years, I would like to run a query where I can see a comparison of sales by year. Customer# Name Year1Sum Year2Sum 1 ABC Company 5000.00 1000.00 2 BAC Company 2500.00 7500.00 I can get the first column SUM to work ok - how do I add the second column in the same results from different records.?

Yea, how do you set the backup to a network drive rather than on the same drive. This is a bad practice....what if the drive crashes.....?

Ok, I need a Filemaker rep to maybe answer this if possible, hmm not probable . There is a Purchase Order database that has two layouts setup. One is for data entry and the other is for printing. The layouts contain fields for "id, description, quantity, unit of measure, price, price unit, and extended amount" these are all fields that repeat 50 times on each layout. They are designed to have borders (left, bottom, top and between repetitions) as well as sliding up (based on all above, with reduce the size of the enclosing part checked). This worked fine in version 6 and now after the conversion the lines will not print in alignment, they step down the page. Is there a solution other than to remove the lines all together. For those over 40 it becomes quite a task to visually align things without those visual aids.... So, in order to get this to print without the stupid stepped lines I have removed all borders. Is Filemaker going to fix all of these issues I am seeing? and there seems to be a lot.