Search results

Thanks for all your answers. Since the DLast function seems to be a little unstable, maybe I need to take a little different approach. I have an autonumber field also in the table. I could look for the highest value in the Autonumber field and read the "BurNr" value for that record. DMax or a...

>Does this make a difference? Code: > BurNr = Nz(DMax("BurNr", "tblParn2010"),0) + 1 >I changed the value if null of the Nz to 0 otherwise you'd get a 2 (with >the +1) Thanks for your reply. I am not able to use DMax function, because the order in which I add data may vary. Lets say...

Hello, I have faced some weird challenges with the Dlast function I am using in a form. Private Sub txtHonaID_Exit(Cancel As Integer) Dim BurNr As Integer BurNr = Nz(DLast("BurNr", "tblParn2010") + 1, 1) Me.cboBurNr = BurNr End If End Sub This is basically the event from the form. So what...

Well, not really. I tried to create a SQL query with Count(DISTINCT), but I didn't manage to do a proper statement.

Hello, I have a calculation issue that I have not figured out how to do. Basically: "In how many records does a specific value appear in another table"? Here is an example how I would use it: Table: tblPersons Fields: Name (Primary key), BirthDate, WorkerID, John, 20.02.1950, 12345 Fred...