Title
Pulling up a selected month and year
Post
I need help in setting up a database. I have been using a database in Appleworks and have imported it into Filemaker Pro 11.
The records have 11 fields. All are text fields except the last service field is a date field.
I need to be able to pull up the records from a particular month and year. In the last service field, a date field, the date is entered for example as 1/3/12 for January 3, 2010.
When creating a new record I want to be able to simply enter the date into one field. How do I set up my database to be able to pull up one month of records?
Also, I have set up layouts to print on postcards. When I have tried to print a set of records it has only printed one at a time. I need to print the whole set of records on separate postcards. I have tried this with the View on both list and table. And I have the Print dialog box set to print all the pages, and the record being browsed.
Wouldn't that be 1/3/12 for January, 3, 2012?
If you enter find mode and use 1/*/2012 as your find criteria, you should be able to find all records dated in the month of January for the year 2012. This can also be scripted so that a single button click or a selection from a drop down menu triggers the same find.
Also, I have set up layouts to print on postcards.
What kind of layouts? Are the postcards perforated stock with an Avery Number? Did you use the labels option when creating the layout and specify that number?
If these are single post cards, you'll need to specify a custom paper size that matches the postcard in printer setup.
If you created a layout for multple postcards to a page stock without using the Labels option, you'll need to use layout setup | printing to specfiy that you are printing data in columns. You'll also need to specify a size for the header, body and footer parts of your layout to match your stock. The body should be sized to the height of a single post card. While in layout mode, you can click the layout part's label and then enter a height in the box of that name on the inspector's position tab to specifiy a precise size for a layout part. (You can click the units to the right of these boxes to cycle from inches to centimeters to pixels to get the units you want.)