Find Problem

[Steve Faulkner]

Hi Guys

I have a problem perfoming a find in FM7.

I created a database in FM 6 for entering all my invoices.

I created a script that would let me see how much I had invoiced in any month and year. Within the script I used a "Set Field" function for the month and year. I had the 'Report Month' as a drop down menu with a value list laid ouy as follows.

1 - Jan

2 - Feb

3 - Mar..etc

In FM6 when I set this Global field as a number the find criteria would only pick up the number part of the field. Now in FM7 the find returns no found records. If I edit the value list to show the number only the find works. Is there another way I have to layout the value list in FM7 ?

Does anyone have a better way of finding records in a given month and year by performing a script?

Thanks a bunch

Steve

[transpower]

In the invoice date field on the find layout, you could enter the range you want, like 01/01/2004...01/31/2004 (for January). You could also write a script with buttons on the layout for each month; this would save you from entering date ranges. Even better would be to set up another related file with summary fields from the invoice table.

[-Queue-]

Number fields behave differently in 7. See here for more detail. Try using GetAsNumber(globalnumberfield) in your Set Field step.