Generate record report from another table by month/year?

[Jman626]

Hello,

I have a table of a bunch of video production project records. Each record has the fields:

-Date

-Client

-Project Name

-Project Number

-Producer

-Cost

I am wanting to create another table that I can input a month/year into a text field at the top, and generate a report of all the records from the video production table for that month/year. Anyone know a way to do this? Thanks!

[comment]

You don't need another table for this - you can add two global fields to the same table (or any table, for that matter). If you use numbers for both, you can then make a script like:

Enter Find Mode []

Set Field [ Projects::Date ; Date ( Projects::gMonth ; 1 ; Projects::gYear ) & ".." & Date ( Projects::gMonth +1 ; 0 ; Projects::gYear ) ]

Perform Find []