IplayWoW

Ya, That's why I changed it to your initial suggestion where you dropped the Pattern Count. Furthermore I decided to make the field contain a drop down list and is validated by that value list. So the field values are limited, but you make a good point.

That's what I was attempting to use but I wasn't working. I'm not sure what was going on...

Wow, I didn't even think to use a reversed statement. I'll have to keep that in mind for future calculations. Thanks, I appreciate it. Tom, thanks for that as well. The rules of this database change from time to time so adding additional "Types" might occur. Adding another condition is easy enough, I was just having HUGE brain fart. I'm on a low carb diet and I feel kinda hazy.

I don't know if I'm having a major brain fart today, but I can't figure this out. What I have: Case( PatternCount( Type; "Receipt") = 0; Expense) What I need is if the Type = "Receipt" OR "Mileage" to return 0 (False).... but I can't seem to figure it out Can someone point me in the right direction? -Thanks -VX

This is among my main concerns. I've done similar setups for the client (friend) and they always have complaints about not being having a similar format to the original file. I agree with a new record for each expense, because you're 100% correct about not being able to get information out. In the long run, they are easier for tracking information... that being said, I think this is beyond the means of the client. For me, this is one of the annoying situations where you're torn between doing what is CORRECT and what THE CLIENT WANTS....

I'm eager to learn, so I look forward to an example (if of course, you have the time). Thanks LaRetta

What would you recommend? Just doing a portal setup via a related database? Again, I'm more of a beginner so I'm confused as to the logic/advantage of the portals vs. repeating fields in this scenario. Someone helped with an alternative way of doing this by running a Pattern Count and returning the expense cost as 0 when the Expense Type = Receipt, but it was rather cumbersome and aesthetically displeasing to have to do a "Receipt" field after each incidence of expense.

I don't believe so, from my understanding, they just want to be able to generate a quick and easy report for submitting travel expenses. Tracking expense over a period of time is beyond the scope of their needs. They just want to be able to record expenses, receipts, etc into a database and be print a record for accounting.

I'm trying to make a calculation for a field that Gets the Repetition # of a repeating field. My ultimate goal is to make odd numbered repetitions (containing a price) to be added to a subtotal field AND the even numbered repetitions (containing a receipt number) to return as 0... thus, not being amended to the subtotal field. In addition, I need the subtotals to correspond to the Expense Type field (something that I don't even know if it is possible) I can't seem to get it to work... any ideas? Can someone point me in the right direction? Please see attached file. Thanks in advance Report.zip

I'm looking at the file now, It's perfect! Thank you so much. I truly appreciate the help!

If it would be better to establish this via a Portal & a related database, I could do that too... but I don't think that'll make it any easier.

I'm in the process of developing an Expense Report Database that is VERY similar to the preset Expense Report template of Filemaker 9... There are repeating fields that span a period of 1 week (7 days) for a total of 24 possible repetitions. I have everything set up fine and dandy... all of my calculations are working properly, the sum of fields, subtotals, totals, Rate per Km., etc... So here's the problem: There is a sudden need to include the receipt number (whether it be a series of numbers or letters) somewhere to validate the expense... but because these are calculation fields it adds the receipt numbers into the totals. Can anyone think of a way to resolve this issue without doing a drastic overhaul on my preexisting work? I have included the FM9 Expense Report that I am referring to... My calculations are virtually the same Expense_Report.zip

Thanks for your help. I'll give 360 a call.

Ya, I've wanted to use an FTP server for ages now... but 1) My boss is Filemaker crazy... everything has to be integrated into one, easy system. 2) The users (my boss) would have difficulty navigating to an FTP server. So it wouldn't work.. Haha. What MIME should I be using? I have [ "data:application/pdf," & File::Container ] and I keep getting some error message saying "File doesn't not begin with '%PDF-'"

In my search I came across this example but I didn't understand how to deploy it. I tried it earlier and all it did was display the name of the File in the webviewer, as opposed to the actual file itself.