Outer Joins in FileMaker 12, part 1 | filemakerhacks

Kevin Franks blog is  must read, especially if your are using (or trying to use) Execute(SQL)…

Outer Joins in FileMaker 12, part 1

Recently I had an on-screen reporting challenge, and decided to try several different approaches to see which would be fastest. The challenge: Starting with two tables, one containing 20 Employees, and one containing 2,000 Sales records for the current year…

…display daily sales totals per employee in a seven-day grid, like so:

More…Outer Joins in FileMaker 12, part 1 | filemakerhacks.

Liked Liked
Need FileMaker Development Help? Or to purchase FileMaker Software?
Contact FM Pro Gurus for help