Automated values in a table

  • Thread starter Thread starter Radhika
  • Start date Start date
R

Radhika

I have a table which inculde two fileds. Field 1 called "Injection" is a
Yes/No box. Field 2 called "#of Injections" is a number column. I want to
have an automated function, where if "No" is selected in "Injection", "# of
Injections" automatically fills in a value of "0". How do i do this in a
table?

Thankyou!
 
Hi
What if you just made the default value of the second field "0" that way
you wouldn't have to worry about it if its " No" and if is "Yes" you would
have to edit it anyways with a quantity right?
 

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

Automating data in a table field 2
autofill values from one table to another 5
Cross-Tab CSV Records 5
SQL Injection in Access 17
Summing Data by date from different tables 3
timer issue 5
Control instance from different framework version. 1
Automated Security Testing 2

Back
Top