Table default value - expressions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to use the Iff function to enter a default value in a table (field 1),
the Iff will be conditional on the content of another field (field 2) in the
table. The "normal" data entry to the field 1 is a lookup table.
I have tried but it complains about both field 2 and the expression - I am
stuck!
Grateful for any suggestion or tell me if it impossible
Pete R
 
You can't for a table.

You should be able to do it for a form based on the table, which should be
all you need, since you should never be working directly with the tables
anyhow.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Property sheet data missing also syntax 0
Default Value 3
Creating a Default Value 1
Default Field Value 3
Value Table 2
Default Value from Another Table 2
Field Default Value 0
Update UnitsInStock 8

Back
Top