Return result based on %

[Guitarzan]

I have a table that has 3 columns: Unique number, Date, and Results



I want the user to enter the unique number and date into the form. Then the "results" column/field will autopopulate a 0 or 1. I want it to populate a 0 85% of the time and a 1 15% of the time. This should be cumulative (meaning not every entry has a 15% chance of being 1). Is this possible? (if it makes sense)

[pbaldy]

I'm sure it's possible, though I suspect it will require code (perhaps a function). Basically you'd compare the total number of existing records to the number with 0 and get the percentage. If it's under .85, return 0, else return 1 (or whatever your specific math requirements are).