Recent content by Jeremiah32

Code syntax updates field (intNoUnits) based on primary (strProviderName) and foreign (strSubsidy) keys. I noticed that when the value has been changed, the field value remains the same unless I exit and reenter the form. I tried including Docmd.requery and me.requery at end of the "End With"...

I’m working on a forecast project where I’m trying to identify number patterns that involve values of zero or/and one that occur within consecutively within a three month period over an 24 month history. The table I’m working with is a text table that has over 800,000 records. The function...

Thank you.

I found an array function that returns a true and false column values in a row are zero for mimumn of three consecutive times. Function works fine,, I was wondering cna the function be modified to identify consecutive values of zero or one? I'm working with a query that is linked with txt file...

I seen this before, but I can't remember how it was done. I googled the topic but I'm not having much luck. I'm looking for a formula that would give the row number in a query. Kinda like autonumber function new creating a table.