T
TimM
Ok I’m trying to fill a field from a table based on what I input on another
field also relating to that same other table.
The other table name is ‘Callers’ with the fields Name, Emplid, Store Number.
I’m trying to fill the Name and Store number fields on my form (that is
based on another table ’Call Log’) when I enter the callers Emplid.
Not sure how to do this, I’m sure it can be done I have it working quite
well in an excel spreadsheet, but I’m deciding to move it to an access db for
better speed.
This is the formula for excel:
=IF(ISNA(MATCH(C3971,Data!B:B)),"",INDEX(Data!A:A,MATCH(C3971,Data!B:B,Data!A:A)))
and there’s another one for the store number field. I’m sure knowing that is
not necessary but why not right.
This formula I have currently returns an N/A when it does not match an entry
in the 'Callers' sheet in excell. Is this possible in Access as well.
Hope some one can help,
Thanks a million.
field also relating to that same other table.
The other table name is ‘Callers’ with the fields Name, Emplid, Store Number.
I’m trying to fill the Name and Store number fields on my form (that is
based on another table ’Call Log’) when I enter the callers Emplid.
Not sure how to do this, I’m sure it can be done I have it working quite
well in an excel spreadsheet, but I’m deciding to move it to an access db for
better speed.
This is the formula for excel:
=IF(ISNA(MATCH(C3971,Data!B:B)),"",INDEX(Data!A:A,MATCH(C3971,Data!B:B,Data!A:A)))
and there’s another one for the store number field. I’m sure knowing that is
not necessary but why not right.
This formula I have currently returns an N/A when it does not match an entry
in the 'Callers' sheet in excell. Is this possible in Access as well.
Hope some one can help,
Thanks a million.