The usual separator in DLookup is a comma.
Perhaps it needs to be a semicolon where you are located.
Do you use a comma for decimals e.g 3,25 rather than 3.25?



If so, suggest you mention that in future posts