Is it possible to pre enter data into tables when for instance a new customer is entered then the fields Accounts.Order becomes 0 and Accounts.Price becomes 0 ON Customer.ID=Accounts.ID on the fly?!
Customer
ID
Name
Adress
...
Accounts
ID
Order
Price
Hmm...?! :)
Hi there, I can't seem to get this to work CPR NZ: NZ([Bil_CPR];0) in a query. It should return 0 (zero) if the field [Bil_CPR] is null...?!
What am I doing wrong?!
When I create and run a Query, based on several Tables, and want to surpress fields that generate "#Error" and wants to write "0" (Zero) in that field instead...
How to...?! :o/
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.