Hello, I've been a FM7 user for 4 years now, and I do consider myself to be pretty well aware of what can be done and what can't. However this request threw me for a loop this morning.

Our accountant asked for a report of all orders that shipped out of state in 2007. In my mind, I'm thinking that means I need to find a ship date of 1/1/07...12/31/07 AND the state does NOT equal MN.

I am aware of the 'omit' flag for finds, but have never really needed to use it. I'm not sure how that would help me in this situation since I also need to limit the year to '07.

I'm stumped. I ended up just making a copy of the file and butchering the copy to get what I needed ( just deleting records I don't want to account for ), but I'm surprised that I couldn't do it right in the first place. Can anyone make a suggestion as to what I missed?

An SQL equivalent of what I want would be:

SELECT * FROM db.Orders

WHERE SHIPDATE LIKE "2007%"

AND STATE != "MN"

Two request for the same find will be needed.

Enter Find Mode

enter your range for shipping date

1/1/2007...12/31/2007

New request (in Find Mode, it is the same as a New Record)

enter the MN in the State Field, and then choose the Omit

HTH

Lee

Enter Find Mode []

Set Field [YourDate; "1/1/07...12/31/07" ]

New Record/Request

Set Field [state; "MN"]

Omit Record []

Perform Find []

Awesome!

Thanks Lee, I didn't realize that the 2nd find request would also inherit the ship date limitation of the first request.

I assumed a 2nd find request was a concurrent OR type of request (in this case, allowing any ship date).