MS Access 2003 - What is the equal function in code?

What i开发者_开发技巧s the code for an equal function?

This values in this column and the values in this column and the values in this column all equal this column.

Your question is a bit vague but I'll assume you mean "How do you do this in SQL?"

Columns in the same table

SELECT column1, column2, column3, column4 FROM myTable
WHERE column1 = column4
AND column2 = column4
AND column3 = column4

If on the other hand you meant to compare the total values of columns 1, 2 and 3 to column4 it would look like:

SELECT column1, column2, column3, column4 FROM myTable
WHERE column1 + column2 + column3 = column4

You can learn a lot more about SQL's syntax by taking a look at http://www.w3schools.com/sql