trying to convert from Access - need help!!

[Cin]

I have an Access database that I've created but need to move it into filemaker. I have most of it created, but need help with my monthly report. When I run my report in Access It asks for the date range. It then gives me all the accounts and the detail for that range. I have a subreport imbedded that gives a total of all prior entries as a beginning balance. I then add the beginning balance and the range detail for an ending balance in the group footer.

How do I recreate this "subreport" for the beginning balance. Can someone point me in the right direction?

Cin

[kassetra]

If your "prior entries" are included in the range of your report, you can create a simple summary field to give you a beginning balance.

I suspect, however, that you want to see a report for a specific range, and that the records that happened prior to that range you want to use as your beginning balance; if this is the case, there are a few ways you can accomplish this task.

Here is a way I might try (you will need to write a script(s)):

Fields:

1. Create a summary field that points to your balance field.

2. Create some global fields: beginning date, ending date, beginning balance, ending balance. (if you don't already have them)

Script:

1. Store your date range beginning and ending dates in two global fields.

2. Do a find for all dates prior to the beginning date.

3. Set the beginning balance field to the summary field.

4. Now do a find for your date range (between beginning and ending date)

5. Set your ending balance = beginning balance - summary field.

6. Display on your report.

hopefully that works for you.