Auto populate field#1 if field#2 is null
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I want to have a field (field 3) auto-populate based on what is entered into two other fields (field 1 & field 2).
Field 1 is a date field (when a presentation is due). Field 2 is a yes/no checkbox (if checked, it means no presentation is necessary). Field 3 would be a calculated text field (?) because text cannot be entered into Field 1.
If field 1 is null and field 2 is checked, then I want "NA" to auto populate into field 3. However, if field 1 is null and field 2 is not checked, I want "TBD" to auto populate into field 3. If field 1 is not null, then I want field 3 to be null
I have to create a new table, with a new field populated with the contents of the last populated field.
in other words. if the 12th field is not null, populate fieldnew with the contents of field12
if field12 is null, then if field11 is not null,populate fieldnew with the contents of field11 |
if field11 is null, then if field10 is not null,populate fieldnew with the contents of fieldl10
if field10 is null, then if field9 is not null,populate fieldnew with the contents of fieldl9
if field9 is null, then if field8 is not null,populate fieldnew with the contents of fieldl8
I then realized that with that setting users can enter duplicate data. When I changed Indexed to Yes(No Duplicates) I lost the auto populate function.
I would like to have the best of both worlds. I need the field to stay Unique as well as populate those 3 fields.
This would be similar to how Office or Word does an auto type based upon the initial letters typed.
I've searched the forums and found a number of inquiries regarding auto population, but they're usually tied to another field or table, not the same field in the same database
I need to convert that field to a date/time one. Which is being hindered by these values of NULL.
The problem is that when I put the word NULL in the field criteria spot, Access believes that I am referring to a value of 'null' and will not do the update.
I have done "NULL", NULL, =NULL, ="NULL", is NULL. and no success.
Please remember that the actual value is not 'null'. It is a text field that has the word NULL in the field.
I tried having a column in the query that the form is based on to have a default value of date field + 90 but it doesn't work
I have an employee table that shows employees and some basic information about each of them. This table has an employee ID field that is not an autonumber but it is unique to each employee (10004928).
I have other tables that also use that same field and I want the first and last names to auto populate based on the main employee table. These other tables are tracking OT and Vacation time used.
How do I make the later tables auto populate the name fields when you key the employee ID?
The form will only auto populate new records. not existing records.