J
Janis
This query should work. The _HSIRouterImport tbl has the data in it I want.
There is one field called Avail 2NOd D/S for HSI?, a yes/no field from a
linked Excel sheet called DualDSNodes. I want to add that column to the
_HSIRouterImport tbl. I am not getting any data in the datasheet. Could it
be because the Excel sheet field is probably a text field and I have the
impNodeNumber field is a text field of 255 length. The Node Fwd Tx is from a
linked Excel spreadsheet. I assume it is a text format in Excel. How can I
get that column added to my _HSIRouterImp tbl?
SELECT [_HSIRouterImport].*, DualDSNodes.[Avail 2NOd D/S for HSI?]
FROM _HSIRouterImport INNER JOIN DualDSNodes ON
[_HSIRouterImport].impNodeNumber = DualDSNodes.[Node Fwd TX];
tia,
There is one field called Avail 2NOd D/S for HSI?, a yes/no field from a
linked Excel sheet called DualDSNodes. I want to add that column to the
_HSIRouterImport tbl. I am not getting any data in the datasheet. Could it
be because the Excel sheet field is probably a text field and I have the
impNodeNumber field is a text field of 255 length. The Node Fwd Tx is from a
linked Excel spreadsheet. I assume it is a text format in Excel. How can I
get that column added to my _HSIRouterImp tbl?
SELECT [_HSIRouterImport].*, DualDSNodes.[Avail 2NOd D/S for HSI?]
FROM _HSIRouterImport INNER JOIN DualDSNodes ON
[_HSIRouterImport].impNodeNumber = DualDSNodes.[Node Fwd TX];
tia,