Skip to content
Advertisement

Access Query – [col]/[col].[col]?

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]... 
User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement