Jump to content

Search the Community

Showing results for tags 'calculations'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Custom Function Library

Community Forums

  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Custom SSL Certificates
    • External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker REST API
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • FileMaker Interface Features
    • Cards & Window Management
    • Interface Design Discussions
    • Layouts
    • Themes and Styles
    • Button, Popovers, Button Bars, SVG Icons
    • Tab and Slide Control Panels
    • Portals
    • Web Viewer
    • Conditional Formatting
    • Custom Menus
    • Value Lists
    • Tool Tips
  • FileMaker Schema & Logical Functions
    • Managing Scripts
    • Calculation Engine (Define Fields)
    • Custom Functions Discussions
    • FileMaker Query Language or FQL
    • Relationships
    • Charting
    • Remote Container Fields
    • Finding & Searching
    • Importing & Exporting
    • External Data Sources
    • Advanced & Developer Features
    • Reports, Printing & Publication
  • Brain Food
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • OS Level Database Automation
    • Hardware & Networking
    • Bar Codes (Printer, Scanners, Software)
    • Accounting Solutions
  • FileMaker Discussions
    • FileMaker Pro 16
    • FileMaker Pro 15
    • Legacy FileMaker Platform Discussions
  • Productive Computing Support Forums
    • Visit Productive Computing
    • General Discussion for Productive Computing Products
    • Core CRM Solutions
    • QuickBooks and Accounting Plug-ins
    • Contact and Calendar Management Plug-ins
    • FileMaker Utility Plug-ins
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • 360Deploy
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • FM Forums Affiliate Sponsors
    • Monkey Bread Software (MBS Plugin)
    • SyncServer Pro by LinearBlue
    • ISO FileMaker Magazine
    • Open Source Frameworks
    • FileMaker Plug-Ins
    • User Group Central - Sponsored by FMPug.com
  • FileMaker Classifieds
    • FileMaker Product & Service Announcements
    • Professional FileMaker Training
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • The Water Cooler
    • Member Lounge
    • Wants & Wishes
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Site Instructions
  • FileMaker Platform


  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • CampSoftware, Hal Gumbert
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker
  • Button Bar Icon - Text Alignment Issue
  • 1-more-blog
  • Productive Computing


  • Samples
  • Solutions
  • White Papers
  • Plug-Ins
  • FMGo

Found 28 results

  1. I have the following: Table 1 – Expenses Field A: Date Field B: Concept Field C: Amount Table 2 – Flight Time Field D: Date Field E: Flight Time (in hours) I need a report that will give me the expense cost per hour, i.e. the total of Field C divided by the total of Field E. Table 1 and Table 2 are not related. What relationship must I establish between them to obtain my desired result? If establishing a relationship between the tables is not the answer, how else can I achieve the figure I need? Thank you for any help that can be provided.
  2. There are three tables: Services ServiceTransactions ServiceTransactionLineItems Relationships: Services:materialName::ServiceTransactionsLineItems:Material_FK and Services:MaterialYear::ServiceTransactionLineitems:TransactionLineItemYear (Services may change from year to year, and within one transaction you might line items for both current and future years.) ServiceTransaction:TransactionNumber::ServiceTransactionLineItems:TransactionFK :Services:MaterialBudgetAllocation is a user entered number. What I am hoping to do is: Get the yearly total amounts of each material (Material_FK) and subtract that from Services:MaterialBudgetAllocation to get a remaining amount.
  3. As most people here probably know, the Let ( ) function can be used to define a Local variable. As such, it is possible to build a custom function that defines such a variable, and it is further possible to set said variable to a value including itself. An example would be the following custom function, ErrorList, consisting of the following calculation: Let ( $ErrorList = List ( $ErrorList ; Get ( LastError ) ) ; "" ) If a Set Variable script step sets the same variable as a custom function like the one above, e.g. Set Variable [ $ErrorList ; Value: ErrorList ] …the script step will run appropriately, so long as the contradictory variable—in this case, $ErrorList—is not yet defined. However, once this variable has been defined, executing the preceding script step will cause FileMaker 14 (and perhaps other versions) to suffer an Error #1213 and crash the application. The workaround for this behavior is to have the Set Variable script step set a dummy variable, e.g. Set Variable [ $x ; Value: ErrorList ] Even if $x is not referenced anywhere, having a script call the ErrorList function passes the variable $ErrorList to the script’s own context, thus allowing its value to be accessed by later steps in the same script (including subsequent calls to the ErrorList function itself). In FileMaker 15, this behavior has been changed: local variables defined within a custom function are now valid only within the scope of the function itself, including any recursions. While this alleviates the problem of application crashes, it also results in unexpected behavior when scripts written in earlier versions of FileMaker rely on custom functions to set local variables. When migrating to FileMaker 15, each affected script step must be updated to set the target variable explicitly instead of relying on the custom function to do the work. In other words, the code: Set Variable [ $ErrorList ; Value: ErrorList ] …which proved fatal in FileMaker 14, is now required grammar for FileMaker 15: FileMaker 15 believes that what happens in the function stays in the function, instead returning the result of the calculation to the variable defined in the Set Variable script step. The FileMaker 14 grammar, Set Variable [ $x ; Value: ErrorList ] …thus sets $x to the intended value of $ErrorList while leaving the value of $ErrorList as null. Unfortunately, this cannot work effectively in a mixed-installation environment: the FileMaker 14 grammar leaves FileMaker 15 clients with unintended null values; the FileMaker 15 grammar causes FileMaker 14 to crash. When upgrading all users to FileMaker 15 is not feasible, the best workaround is to use the FileMaker 14 grammar, then once all relevant script steps are complete, check the value of the intended variable (e.g. $ErrorList) and, if empty, set it to the value of the dummy variable (e.g. $x). ErrorTest.fmp12
  4. Hello, I am new to FileMaker and still trying to find my way around the scripting language. Even though the scripting language is quite rich, I don't feel as comfortable and flexible as I do in lets say VB. To my query now; I have designed a solution for my company which processes invoices. These invoice forms input numerical amounts tied on budget codes for each department and in turn are stored in a different table. As you can see on the image attached, I cannot find a calculation function that will sum all the amounts for each BudgetCode into AmountAllocated. AmountAssigned is the yearly department budget predefined. I will be grateful for any suggestions or ideas. Thanks
  5. I have a Layout in Table Mode as (partially) shown in the attachment. (Note: First row will have a Country Code in it - not shown in attachment) I want to "fill-down" the last country code in all rows (in the Country Field) UNTIL the country code changes. Then I want to similarly do it for that one. Until I reach the end of rows. My database will grow from 500 to 10,000 rows of text/number data. I am uploading in batches from Excel. Is this possible? I've tried various calculations and scripting without much success. Thanks! I'm trying to get something like this: COUNTRY IT IT IT IT IT IT IT IT ES ES ES ES ES AU AU AU AU AU IN IN IN IN .......etc
  6. Charts from value list

    Hi can anyone point me in the right direction, I have a database that as a Field populated by a value list, i.e.,: Christmas,Easter,Mothers Day , etc. I want to chart how many records exist of each chosen category. I thought it would be from a summary field using Total of and count but that option isn't available, How do I get filemaker to count the number of uses of the word Christmas from that field , can anyone help please? Thanks in advance
  7. FileMaker 14 SVG Icon Helper - Rev 2 | FileMaker 14 Training http://youtu.be/nk1lWHZ0AhI Download the FileMaker Pro 14 & FileMaker 14 for Mobile Devices Training Videos athttp://www.learningfilemaker.com Please Visit Our Channel: https://www.youtube.com/user/FileMakerVideos Please Subscribe While There. This updated Revision 2 (August 2015) features Claus Lavendt, of DataManix, showing a free FileMaker solution that helps customize SVG icons for use on FileMaker 14 buttons. Download a free copy of the SVG Icon Helper Tool here: http://fmstartingpoint.com/market.html Richard Carlton Consulting, Inc. provides customized database development services for business, government, and non-profit organizations. Our core competency is FileMaker Pro, where we hold FileMaker's highest certifications. With a team of 27 staff, we are capable of deploying both small and large solutions for a wide variety of customers. We service all modern versions of FileMaker Pro, FileMaker Server, and FileMaker Go (for the iPad and iPhone). We also deploy FileMaker databases to the web, and offer PHP/Web Development, iOS Programming, FileMaker Server Support, and Hosting Services. http://www.rcconsulting.com/ Please feel free to contact us at support@rcconsulting.com Looking for FM Starting Point free software download: http://www.fmstartingpoint.com For More Free FileMaker Videos Check out Http://www.filemakerfree.com Please Comment, Like & Share All of Our Videos. Feel Free to Embed any of Our Videos on Your Blog or Website. Watch a FileMaker Training Review Video Here: https://www.youtube.com/watch?v=reoBiKXlv54 Follow Us on Your Favorite Social Media https://www.facebook.com/FileMakerVideos https://twitter.com/filemakervideos https://plus.google.com/+FileMakerVideos/videos
  8. Placeholder text is a great new feature in FileMaker 14. With it you can specify by calculation what label text is to appear in a field that is empty. You can also have complete control over the styling of that text. In this article we demonstrate how to setup a placeholder and some of its benefits over standard labels. We also show how placeholder text can be used as a powerful user interface tool for displaying virtually any calculated value direct on a layout without the need for fields or variables. Click here to check out the full article at FileMaker Weetbicks
  9. Hello! I am trying to write a simple calculation that is proving to be more difficult than I thought. I have a real estate database with the tables: properties, transaction, and people. A property can have multiple transactions associated with it, and each transaction has people attached to it (buyer, seller, broker). I am trying to flag all the properties (in the properties table) when a certain person is linked to any of the properties associated transactions, call this person "Bill". Taking it one step further, I would like to display a "C" when the Bill is associated with a transaction with the status of "Closed" and a "L" when Bill is associated with a transaction with the status of "On Market". That is easy enough and I have that portion working (in the transaction table). The problem is I want the "C" to be prioritized, meaning if Bill is associated with two or more of the associated transactions for one property, and one of those transactions status is "Closed", and the other is "On Market", I would like a "C" to be displayed in the property table. The way it is set up now, I can only seem to look at the most recent transaction (based on closing date) and display either a "C" or "L" depending on the status of the most recent transaction. Sometimes the transaction with the status "Closed" is more recent and vise versa. How can I set this up so that the calculation looks at all related transaction records, determines if any are flagged with either a "C" or an "L", and if there are both, display the "C"? Any help would be appreciated!
  10. Hi! I have an Hours Sheets table, and hour sheets are created per month. I have Absences table which has absences specified by start and end date. and I have a Calendar days table, which is related with Absences with start date and end date. Now, When I create an absence spanning over two or more months, (e.g 26th March to 5th April) I want to get related calendar days for the particular month in hour sheet. (i.e if I create an absence from 26th March to 5th April I want to have 3 days (26th, 27th and 28th) in hours sheet of February month and 5 days (1st, 2nd, 3rd, 4th and 5th) in hours sheet of March. I am not able to find a way to separate out the days based on a month. ( I can not use portal filter, since I need the days to use in calculations) I have attached a sample file. Any advice/suggestions will be greatly appreciated. Thanks! absences.fmp12.zip
  11. Hi all, I'm hoping you can help here. I am trying to make a calculation on a layout. I need to calculate measurements of a specific drop down value that I write in a specific field. The value is called "pool." There are other values called "rapids" and "riffles" etc., but I need to write a calculation that finds running totals of the lengths between the "pools." Is it easier to run a script? If so, how to do I do this? FYI- I have another field that gives unit lengths. Again, I want to calculate the unit lengths between the value "pool". I hope this is clear enough. Ideas? Thanks!
  12. There is probably a simple solution to this problem that I'm not seeing but I've read through my entire 900 page FileMaker Pro Missing Manual and I can't find the appropriate answer; I'm using FMP 13 Advanced and I have some basic experience writing scripts, etc. Here's The Goal: To start each day with a screen report of tasks to complete for my client files. I want a report that says 'today you must take care of the following items..." To keep it simple, I have a client table & a transaction table. For each transaction that I handle for my client there is at least 25-35 documents to complete. Certain documents are completed at the time of sale and other to be done during & after the sale over several week's time. It's difficult to keep track of what forms have been completed. Also I could be handling several sales at the same time compounding the administrative challenge. I do this manually now. Currently I use a simple chart layout with checkboxes that I manually fill in as each task is completed for each sale but I'd like to have it automated with daily reminders of forms still needing to be signed today, 1 day from now, 7 days from now, etc. It's easy to create a single date calculation field that says I have "X" number of days until the deadline for one item but can I do this for 25-35 reminders and ... (Here's the challenge) have a daily report telling me what is still due? I'm thinking I may have to create a "task" table that would have a related record for each one of the forms I need to complete on each client and have it connected to my transaction table. Then a script to search all relevant dates across all records. But that seems like so much redundancy to have 30+ records for one transaction file. Is there an easier way? Thanks in Advance!
  13. Hi there I am on the hunt for a function or calculation that will operate like the native Extend () function but I need it to grab the data from another related REPEATING field instead for a non-repeating field which is the limit of the Extend () function. To give a bit of background on what I am doing, I have built a responsive image grid and a responsive notes grid very akin to the Facebook interface. I am at the finish line. The last thing I need to do is add "Edit" and "Delete" options to the bottom of each repetition in the portal (like a Facebook post). All other items in the grid are populated using the extend function and it works as it should of course because they are non-repeating unique data points. The structure is simple. I have a Contact table, a notesdisplayrows table, and a notes table. All data points are calculated in the displayrows table. Example: GetNthRecord (Extend(CONTACTS_NOTESGRID::ID); Get(CalculationRepetitionNumber)) However, where the "Edit" and "Delete" options are concerned I need something that will grab both the 1st and 2nd repetition of a field so that they will display as lower menu options for each repetition (I.e. Facebook). I currently have a repeating field in the notes (notesgrid) table and the 1st rep is "Edit" and the 2nd rep is "Delete". Any suggestions?
  14. Hi there, I am extremely new to filemaker but trying to learn on my own. I am creating a betting pool with my friends for this upcoming football season. I want to calcuate how many picks a person got right based on calculating their weekly record and then calculating their overall record. I know this is simple but I can't seem to figure it out. The fields I want to evaluate in my layout "week 1" are: Winner - Team that covered the spread Scott - What team I picked that week The first thing I did was create a calculation field(Scott Weekly TrueorFals) with If(Week 1::Winner = Week 1::Scott; 1; 0). This told me if I picked the correct team I got a 1 and if I did not I got a 0. Then from there I want to calculate how many 1's (wins) and then how many 0's(loses) there are for the week. This is the part im stuck on. Can someone please help me? Thank you in advance.
  15. I have a checkbook journal with a calc that figures the balance. I know this should be easy, but I am having a hard time figuring out how to capture the balance daily (the end of the day) and do a simple report, list, or portal that shows the daily balance. ((kind of what you see when logging in to your bank). Any ideas anyone? Than you in advance. Amy
  16. This is probably an easy design concept, but my dense brain isn't seeing it. I'm working on a timecard system, and I'm running into a problem where I have co-dependent fields. In my hours table, I have a field which calculates the amount of VTO (Variable Time Off - like vacation time) that is used if the total hours entered on a workday is less than 8. However, the system can only fill the deficit in hours (8 - hours worked) if you have enough VTO available, so the calculation first checks the value of the VTO_Available field from the related VTO_Month table. It looks like this: Let ( [ Worked = TotalHours; Deficit = 8 - TotalHours ]; Case ( Worked >= 8; 0; //No VTO needed to fill in for the current date Deficit > 0 and (VTO_Month::VTO_Available >= Defict); Deficit; //If there is enough available VTO to cover the time deficit, return the amount of the deficit Deficit > 0 and (VTO_Month::VTO_Available < Deficit); VTO_Month::VTO_Available; //If some VTO is available, but not enough to cover the deficit, use up the available amount (take to zero) 0 //Otherwise, you can't use any VTO if you don't have any! ) ) //End of Let In the VTO_Month table, the VTO_Available field is calculated as (VTO_Start + VTO_Earned) - VTO_Used. VTO_Used is a calculated field defined as Sum (Hours::VTO_Today). Obviously, I can't have two fields whose values depend on each other, but I can't think of how to set up the design to avoid this problem. I seek your guidance! Help me get to that moment where I smack my forehead and say, "Duh! I should have been able to figure that out!"
  17. Our database has a quotation table. We have a drop down menu for products and one for quantity, total and price. The price field is a calculation field which the calculation is If (Product = "A2 Poster" ; "£10) which works fine. However obviously we have more than one product we sell, when i try to put another product calculation next to this it does not work. How can i have multiple calculations in the price field for each drop down in "Product field"
  18. I'm trying to develop a Sports Competition Management System, which ties in with a few other features for my sports association. We have a number of leagues, based on Gender, Age, etc. which vary in team numbers, for example some leagues may have 12 teams, other only 7. Some teams play each other only once per season, other two + times, it depends on the size of the league. I have a few scripts which combined build the schedule of games (Time, Date, Round of Play) and my next step is how to create a Balanced Schedule for an Even Number of Teams, or a Cyclic Schedule for Odd Number of Teams. Obviously, an IF function determines which Scheduling Algorithm to use, based on the number of teams in that particular league. My problem now is to automatically assign the teams participating in the matches, in a way described at the following links I assume it involves a rather complex calculation at some point in the script, but after searching high and low for some inspiration, and a few trial and error attempts... Nothing tangible to show for it. Even # of Teams (Balanced) Odd # of Teams (Cyclic) My file can be downloaded from this link https://www.dropbox.com/s/3onnzm4w75s08r2/Association%20Admin.fmp12 Thanks in Advance
  19. Complex Subsummary Reporting

    Hello All! I am having trouble building a complex subsummary report efficiently for a real estate database. The report layout is simple: I basically have a layout with 18 columns, all years, 2000-2017. The layout only has subsummary parts, no body parts. The subsummary part I am using to display data is sorted by a field called Micromarket (basically a geographical area). I want to display the number of units built in each year for each Micromarket. I have the report working perfectly, but I had to add many fields to my property table to accomplish this. The fields are as follows: Field Name: Number_of_Units_2000: Calculation: If ( (Year_Built)=2000;Number_of_Units ) and a corresponding Summary field that is the "Total Of" Number_of_Units_2000. I have done this for each year on the report, so I have made 18 Calculation fields, and 18 corresponding Summary fields. I then put each Summary field in its corresponding column on the layout, and for each Micromarket, I am able to display the number of units added in a given year. Is there a more efficient way to do this? I have tried performing a different find for each year within a script, then populating a Merge Variable with the result, but the Merge Variable doesn't behave the same way on the layout as a Summary field does. Any help would be appreciated!
  20. I am trying to chart and analyze sale data. In particular, "Most popular product(from a specific product category) this quarter/month/year/etc" and things of that nature. In this database there are several tables: I will try to explain how they are linked Sales Order -Sales Order Line Item --Product Product Category -Product --Sales Order Line Item For example, I want to see the most popular product during a certain fiscal quarter do do so, I need to filter the line items by the following criteria and then have a calculation of the sum of found line items grouped by product * order quantity: Based on the tables this criteria needs to be met: SalesOrder::OrderStatus /= "Open" (not equal) (i.e. closed/completed orders) SalesOrder::Year=CurrentYear SalesOrder::Quarter = Fiscal Quarter(or can be month or can be omitted entirely) Product::Category="my category"(whatever) I've tried many solutions and getting somewhat close, but I get stuck with Un-Index-able match fields(keys) dues to calculations from related tables or circular references. Any tips would be great. Lastly, I think I can accomplish the same thing with a script and perform multiple searches against the LineItems based on related tables, but wanted to know if there is a more direct way via the relationship graph. I'm happy to provide more details if needed. Thanks in advance.
  21. Below is an image of my Script. Problem Area:(Highlighted in Yellow) Set Field [Table::Vehicle_Description1; $&"VD&$i Goal: Variables $VD1-$VD8 are holding data. I am doing a loop $i which is a counter that increments from 1 to 8. If there is Data within the variable then I want the field Vehicle_Description1 to be filled with $VD1 on the 1st iteration. Current Output: When running the script, assuming data is in $VD1, I am getting VD1 within Vehicle_Description1 instead of what data is within the variable $VD1. What is unusual: The counter $i is working fine. You can see this with the output VD1 InShort: How do you read a variable when you have to concatenate and read a dynamic variable? Any help or suggestion would be much appreciated.
  22. Hello, I've been using filemaker for quite some time and tried to use it to build a "backtimer" log for Live television applications. however, after much searching, i cannot find a "real time running clock" function or plug in that allows a field to be updated with the "current time" in real time(system clock every second). a script does now work for my application as i need to be able to use the database to type notes as the time calc runs in the background. I have not been able to get a web viewer window to work because i still need a script to update the field every second. In my search i have read several times that filemaker cannot do this. I find this hard to believe. Any help is much appreciated. Thx,
  23. Hello, first time poster and FM newbie. I'm creating a DB that tracks sales for a small retail sales team. One table called "Quarter" contains a primary key called "__kp_Quarter" which is a unique identifier of a fiscal quarter. An example would be "2012 Q1". There are also two fields, startDate and endDate, which the user sets to the start and end dates of the quarter. This is entrusted to the user because lengths of fiscal quarters may vary. In another table called "Sale," which tracks individual sales, there is a "Date" field. This is also edited by the user, because some sales are backdated. I'd like to have the field _kf_Quarter, where the content is auto-entered by detecting which quarter's date range contains the sale's date. How is this possible? Is there a better method to track sales by fiscal quarter?
  24. Hi, I have a field in a db that has a value list attached to it and checkboxes. I need to make calculation fields that will look at the field and if it contains certain text, will put "T" in the calculation field. Field Name: FEDHAZ Value List Name: Hazard Category Values: a. Fire b. Reactive c. Pressure Release d. Acute Health e. Chronic Health Since a chemical can have more than one of these values, and be checked in any order, there's quite a bit of variation as to what text the field can contain. I need to make a field, Acute, that if the field contains the "d. Acute Health" text, it will fill the Acute field with the letter "T". I could say: If (FEDHAZ = "d. Acute Health"; "T"; "" However, as you know, that will only work if the only item checked is that one. How can I get the same result no matter which other ones have been checked? Something similar to: IF (FEDHAZ contains "d. Acute Health"; "T" "" What function could I add for "contains"?
  25. I have a table where we do our estimates. This table is used by 10 people. The estimates are comprised of estimates made by telephone, by email, and by a physical person entering our office. I have already created calculations and summaries in this table, even with the percentages for each type of estimate based on the total estimates. I have another table with the the actual contracts that have been made and the summary count of contracts made by each person. This table is used by the same 10 people. Now i need to make another table to give me the summaries of all the data from above by month. The percent of estimates that have become contracts and etc. My problem is with the relationship and the fields in the new table. I am wondering how to do this correctly? Dave

Important Information

By using this site, you agree to our Terms of Use.