jpac

Please excuse my ignorance, but what does this symbol mean

Thanks, is it best to set-up as much as possible in seperate tables and then join them. Just a general question.

HI GUYS, I still get any of this to work for me. I open to any new suggestions. Thanks

Hi Fenton, I tried the solution but I lack the expertise to get it to work. I hand counted the attached file the correct result I'm looking for is 31 total inspections for 34 violations.

Hi, I've tried to apply the solutions you have suggested without success. The problem is my skill level. I'm pretty much a newbe. While I am a ouick study, I don't seem to be thinking in that database mind-set yet. To arrive at the correct answer, I exported the file as a csv file, opened the file in Excel, used the sub-total function grouping by location name, then running another sub-total on the location names to arrive at a grand total of 31 inspection for the 34 violations, Convoluted, but it worked. I do thank you for help.

I am trying to create a script. In the attached file there are fields that list the location names and inspection dates. In some cases there are muptle dates for one location. I want to count Location Names as one inspection and show a total of all inspections. HELP 1-6-200.fp7.zip

The count in that field is not accurate. It counts all location names I want to count location names that have two or more of the same date assigned to them as one.

I am trying to create a script. In the attached file there are fields that list the location names and inspection dates. In some cases there are muptle dates for one location. I want to count Location Names as 1 inspection and show a total of all inspections. HELP 1-6-200.fp7.zip

I have a table with fields that have a yes or no entry. Can I create a new field and write a script that will count all the yes entries and all the no entries separately.

I tried this and it only gave me a total of the total records in the field. I couldn't figure out how to get it to count all the yes and all the no checks in the field.

Hi Guys, I'm trying to create a summary layout report with the attached file. The layout summary is on Layout#3. Want I would like to do is have the summary field count a total of all the yes checks and a total of all the no checks. Can I Do This, with a Check Set Field Please help, The Newbe

Hi Guys, I'm trying to create a summary layout report with the attached file. The layout summary is on Layout#3. Want I would like to do is have the summary field count a total of all the yes checks and a total of all the no checks. Can I Do This, with a Check Set Field Please help, The Newbe

Hi Guys, I've attached a mock-up of a database I'm setting-up. What I'd like to do is have each new record I add post the next month & year using a script. I want the month and year to show in the header. Can someone help. Newbe ,Joe

I'm trying to attach a Filemaker 7 file to a post. I get a message can't attach with fp7 extention. Please help

Hi Guys, need a little help. I have a table with 8 fields, the first is what we call location numbers, the second is employee names. There are a multiple employees assigned to many of the locations. I need to show all employees in one field "maybe a portal" by location. I want to link this information to another table, if you can help with the employee part., i can do the rest. Please Help!!!