lostboyca

I have a list of names which can be duplicated for example each department takes so many spark plugs and I would like it so there would be a running total where only one department shows up on the list with the summary of how many spark plug of which below is an example. Department A | Spark Plug A Department A | Spark Plug B Department A | Spark Plug A Department A | Spark Plug B Department A | Spark Plug B Department C | Spark Plug A Department C | Spark Plug A Department C | Spark Plug A On the list I would like it to show Department | Spark Plug A | Spark Plug B Department A | 2 |3 Department C | 3 Thanks,

I have two database which I would like to work hand in hand. I got one (Database A) that will do the calculation of a summary and I would like the other database (Database : to get updated as well once the total summary has been updated. When I try to make a relationship between the two fields I get a dialog stating that

I have this calculation which is a little sloppy and I was wondering if anyone can help me. (If( tc1_xp_vcd = "Marginal", 1, 0)+If( tc2_xp_vcd = "Marginal", 1, 0)+If( tc3_xp_vcd = "Marginal", 1, 0)+If( tc4_xp_vcd = "Marginal", 1, 0)+If( tc5_xp_vcd = "Marginal", 1, 0)+If( tc6_xp_vcd = "Marginal", 1, 0)+If( tc7_xp_vcd = "Marginal", 1, 0)+If( tc8_xp_vcd = "Marginal", 1, 0)+If( tc9_xp_vcd = "Marginal", 1, 0)+If( tc10_xp_vcd = "Marginal", 1, 0)+If( tc11_xp_vcd = "Marginal", 1, 0)+If( tc12_xp_vcd = "Marginal", 1, 0)+If( tc13_xp_vcd = "Marginal", 1, 0)+If( tc14_xp_vcd = "Marginal", 1, 0)+If( tc15_xp_vcd = "Marginal", 1, 0)+If( tc16_xp_vcd = "Marginal", 1, 0)+If( tc17_xp_vcd = "Marginal", 1, 0)+If( tc18_xp_vcd = "Marginal", 1, 0)+If( tc19_xp_vcd = "Marginal", 1, 0)+If( tc20_xp_vcd = "Marginal", 1, 0)+If( tc21_xp_vcd = "Marginal", 1, 0)+If( tc22_xp_vcd = "Marginal", 1, 0)+If( tc23_xp_vcd = "Marginal", 1, 0)+If( tc24_xp_vcd = "Marginal", 1, 0))/24 What I would like to do is that to make it calculate I would like calculate it with a wild card something like this tc*_xp_vcd = "Marginal", 1, 0 which the * represent a number from 1 - whatever so the formula won't be so long and much cleaner.

Great thanks it work as a charm

I don't understand is there a way I can upload the fp5 db to you and let you modify it for me?

I would like to make a check box that will allow me to make that record read only once the box is check. Can anyone please show me how Lostboyca

I do not understand what u are talking about. This is new to me. I have a layout can I e-mail you directly on what I'm trying to do with some examples? Van

OK to make life easy maybe I'll just use fields to calculate. I have about 20 fields and those fields would consist the text Pass, Fail, Block, Marginal, N/A. For one calcuation I would like it to calculate all the Passes within those fields and then I would like to get a percentage breakdown on how many fields where pass. Hope this help if not I can post an excel sample of what I'm trying to do. Thanks,

I'm new to this filemaker and I would like some simple calculations on how to calculate fields. If anyone can help me with the script or ways to do this calculation I would be very greatful. Can I calculate Repeating fields? I have a field where I would like to do an if statement which contains Pass, Fail, N/A. I would like it to calculate all the Pass which each pass would represent 1. and I would like it to cacluation all the repeating fields. If the repeating fields have 10 then it should calculate all 10 Columns to verify which box has Pass. Thanks,