Just inherited an Access database and trying to figure some things out. For the life of me, I have no idea what this query means.
SELECT [col1]/[col2].[col3]...
Its like the [col1]/[col2]
is the table name and [col3]
is the column. But instead of a table, it is math function (dividing two columns) followed by the column name. SELECT table.column...
.
I thought this might be inherent to someone with Access experience (or maybe this is some SQL that I am not familiar with). If it is not just comment and I will post all of the info.
Advertisement
Answer
SELECT [coly]/[table].[colx]...