What you are asking is very easy, and FM 6 is still an excellent product; its age is no handicap.
You have many Clients in the database, so you will 'Find' only the Client you are interested in. That is not layout-dependent - no matter what records you find they will all use the same layout to display. (Click 'View -> Find Mode', and enter the client's name in the empty TO field. Then press 'Enter', or 'Perform Find'.)
You can limit the bids even further, by searching for that Client name in the TO field, and in the DATE field put >1/12/2010 (say).
You can then sort them by date ascending or descending, if you want.
Make sure you select 'View as list' to get the right effect, and move the bottom of the body up tight to the 3 fields.
To take things to the next step you could add a sub-summary part to your layout, defined as 'when sorted by TO'. Then if you do a search to find only those bids in the last 30 days, and sort all the found set by TO, you would see them nicely grouped together for each Client. You could then add sub-totals, say into the sub-summary part of the layout to show the number of bids in that period for each client (and in total) and the value of them.
Sorry if I've pitched the answer at the wrong level for you, either too high or insultingly low.
Like I said, I am new when it comes to FM, but do like it alot.. I got that done, and in file maker, it looks good, but if I print it, it prints my header with company logo, and the first record, is there any way to force it to print the header and then all the found records on a single page? Sorry for the n00b questions!
When you print in FileMaker, you have two basic print options you can select in the print dialog: Records Being Browsed and Current Record. If you print using the Records being Browsed option, you'll print all the records in your found set. Whether or not they all fit on one page depends on how you've structured your layout.
That worked, thank you so much, both of you!