Recent content by cwitton

For some reason my form only reads 206 records while the table it is based off has 209. Any clues as to where this discrepancy lies?

Thanks Linq its all good now. Many thanks to you both for your help on this.

Ok so it sort of worked. And very much didn't. Now everything comes back and says its duplicate! Any clues John? Private Sub RiskReference_BeforeUpdate(Cancel As Integer) If DCount("RiskReference", "[Policy Details]", "RiskReference= " & "'" & Me.RiskReference & "'") > 0 Then Me.Undo MsgBox...

I have a db with various tables including one called Policy Details. Users use a form to enter new records etc. All the policies have a reference number which acts as the primary key and which is usually generated by a separate application system. There are rare occasions (but they do...

Cheers...got it to all work out fine. Appreciate your help on this.

Thanks for the response. The NZ function does not seem to like the three options - it can address using the estimated percentage if there is no final percentage...but not the offered percentage if there is only that. Also...never used Inner Join before, please elaborate? Many Thanks, C

Hello...bit of a challenge. I am building a database and need to perform what essentially is a simple percentage calculation, with a twist. Background: Two tables: One with the 'percentages' of which there is the offered percentage the company wants to buy of the total, the estimated...