Search results

Galaxiom: Ahh. Since i am new to access i just needed the syntax (is Null). Thank you!!

So i cant use =DLookUp() or something similar to "iif([Table2].[comment] > 0; [Table2].[comment]; [Table1].[comment])?

Cronk: Table 1 is the gross of all data (6 times a year it will be updated and some rows will be added from a new xlsx-file). If i want to edit data i do that in table 2 by writing the id of the row i want to edit and the value i want to add. The task of Q1 is to merge the two tables...

I am new to access and english is not my mother tounge, so i apologize if something is not clear in my description. Background I have one query (lets call i Q1) and I have two tables with identical structure. Table 1: - id - iddesc - comment Table 2 - id - iddesc - comment Table 1...

Thanks, that worked like a charm!

Hi! Thnx for the reply. I tried your solution but i still get the same message.

First of all, i am a real newbie on Access and English is not my mother tounge so i apologize if something is unclear. Background: I have a form where you can edit the content of a table. This form has a onchange macro connected to it. The macro adds a value to a column in the table (if...

That worked! Thank you!

Sorry, I am quite the newbie on Access. I got the duplicate entries from the merged table. How do i delete the obsolete one?

Hi! I have a database with the following tables: - data - datamodifications - mergeddata The "data" table is imported from a large excel file (about 5000 rows and 40 columns) and needs to be updated about once a year. The idea is to use the "datamodifications" table to store all...