D
Dan V.
I read somewhere that minus signs or plus signs in access fields are bad
news.
Is that true? If so this is a major bug with MS Access.
I can't 'cast' using str() if a dash is in the middle of a text field. will
get "#Error" in the query cell.
Example: MDID is a text field with some dashes in some of the rows.
SELECT *, Str(MDID)
FROM 59476;
Also, I ran this update query and the text field join did not update rows if
the join text field had a dash in it like: "12-45".
Update [59476] tbl1
INNER JOIN [59476 update] tbl2
ON (tbl1.SiteID = tbl2.SiteID) AND (tbl1.MDID = tbl2.MDID)
SET tbl1.field1 = tbl2.field1;
news.
Is that true? If so this is a major bug with MS Access.
I can't 'cast' using str() if a dash is in the middle of a text field. will
get "#Error" in the query cell.
Example: MDID is a text field with some dashes in some of the rows.
SELECT *, Str(MDID)
FROM 59476;
Also, I ran this update query and the text field join did not update rows if
the join text field had a dash in it like: "12-45".
Update [59476] tbl1
INNER JOIN [59476 update] tbl2
ON (tbl1.SiteID = tbl2.SiteID) AND (tbl1.MDID = tbl2.MDID)
SET tbl1.field1 = tbl2.field1;