1 Reply Latest reply on Jan 7, 2012 2:43 PM by Sorbsbuster

    New FM11 user needs advice



      New FM11 user needs advice


      I'm in the process of converting my Microsoft Access database to FM11. This database is set up to print a simple monthly dividends/income report from a group of finincial instutions. Several of these finincial institutions distribute income on a monthly bases, others do it on a quarterly basis.

      The key parts in the database are a yes/no field (MONTHLY), and four date fields representing each quarter of the year (QTR1), QTR2), (QTR3), and (QTR4).

      After copying the Microsoft Access data over to FM11, I then setup a Find criteria as follows: MONTHLY or QTR1 or QTR2 or QTR3 or QTR4. MONTHLY=1 and each QTR  as 1/1/2012...1/31/2012. The output was identical to that obtained from Microsoft Access EXCEPT for two missing records. Spent several hours trying to find if there was anything unique about the missing records but to no avail!

      I then did the same thing for Febuary, using 2/1/2012...2/29/2012 as the date field. Again, three missing records out of 61. Note that because of the interest payment schedules differ from month to month, both the missing and included records for each month are not necessorarly identical.

      Any suggestions would be greathy appreciated since I have to solve this problem before I can move over to FM11. By the way, I'm using the Windows version of FM11 but want to move on to MAC version.




        • 1. Re: New FM11 user needs advice

          I'm sure you've done this already, but the first step I would do is to set, in the body of the records you are searching, the fields you are using in the search criteria (MONTHLY, QTR, etc), and then look to see if anything in the 'missing' records doesn't completely match the search criteria as you would expect.  Might not be applicable here, but I also tend to make those fields quite large (width and depth) to make sure I can see if there is any other data in the field, perhaps hidden by a stray return character, or a tab, or a control character.

          If the data in those records' fields looks like it is correct, I'd then delete the data and replace it (with Control-A and Delete) by typing what I think it was anyway, then re-do the find.