A summary field can compute the total for your found set, so all you need is a scripted find that finds all records with the specified date.
Here is a thread with many different scripted find examples--including searching by date: Scripted Find Examples
That link was a great help. The only problem I had was with the If statement Script Manager did not like me entering [Not Get...] but that step is not greatly imprtant to me. My next question is where do I begin to write a report?
The only problem I had was with the If statement Script Manager did not like me entering [Not Get...]
Exactly what did you enter?
My next question is where do I begin to write a report?
That would depend on the design of your database and what you want to see in your report.
[Not Get ( FoundCount ) / / no records were found]
Show Custom Dialog ["These are Not the Records you are Looking For!"]
The message I get says: A number, text constant, field name or "(" is expected here.
As for the Report: OUr database is a very simple one. After I query the Paid date. I want a report that shows me property address, client name, report # and amount. The amount column is what I want totaled.
You have a space where it shouldn't be:
[Not Get ( FoundCount ) // no records were found]
// is a "comment" symbol that tells filemaker "ignore everything to the right of this" when it evaluates an expression.
You need to define a summary field that computes the total of your amount field.
I'd need to know more about your tables (Is this one table or is some of this data from a related table?) and relationships (if any) to say more than that.
ok- Fixed the first line of the IF Statement. On the second line I get the attached image.
This is pretty much a flat table. The Client Column is a lookup all others are entered manually. How and where do I define a summary field. I am not sure of where to even start with the report writing.
The second line is a separate script step. It is not to be entered inside the specify calculation dialog that is used with the If step.
Instead, find Show Custom Dialog in the list of script steps on the left (It's way down in miscellaneous) and double click it to add it to your script.
That works perfect! Did I mention that I have no clue what I am doing? Thanks for all of your help.